Hive Query error

to create new topics or reply. | New User Registration

Tagged: , ,

This topic contains 1 reply, has 1 voice, and was last updated by  Yuvaraj Vijayakumar 1 year, 1 month 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 to reply to this topic. | Create Account

Viewing 1 replies (of 1 total)
Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.