Home Forums Hive / HCatalog Hive Query error

Tagged: , ,

This topic contains 1 reply, has 1 voice, and was last updated by  Yuvaraj Vijayakumar 1 month, 1 week ago.

  • Creator
    Topic
  • #55691

    Yuvaraj Vijayakumar
    Participant

    Hi

    This is Yuvaraj from helios&matheson

    Please help me with below error,

    1. When i try to drop table in hive, i get the below error

    hive> drop table patient_external;
    FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:javax.jdo.JDODataStoreException: Iteration request failed : SELECT A0.COMMENT,A0.COLUMN_NAME,A0.TYPE_NAME,A0.INTEGER_IDX AS NUCORDER0 FROM COLUMNS_V2 A0 WHERE A0.CD_ID = ? AND A0.INTEGER_IDX >= 0 ORDER BY NUCORDER0

    2. When i try to load hdfs data into table in hive, i get the below error

    hive> load data inpath ‘/datagen/datagen_10.txt’ into table patient_external;
    Loading data to table patient_data.patient_external
    Failed with exception Unable to alter table.
    FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

    Regards
    Yuvaraj V

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

Viewing 1 replies (of 1 total)