Home Forums Hive / HCatalog Hive Showing "No data available' even after successful registration and import

This topic contains 0 replies, has 1 voice, and was last updated by  Praveen Kumar 3 months ago.

  • Creator
    Topic
  • #57506

    Praveen Kumar
    Participant

    I have a cluster with 1 name node and 2 data nodes. I am following the first tutorial – http://hortonworks.com/hadoop-tutorial/hello-world-an-introduction-to-hadoop-hcatalog-hive-and-pig/. I have uploaded the example data into HDFS and have registered it with HCatalog. I am able to see the table preview with data and the table is successfully created and data is imported. But when I write a Hive query (Select * from nyse_stocks) to retrieve this data it shows “No Data Available”. Even if I use the ‘Browse Data” option I see empty results. Through file browser if I look at HDFS location I can see this data. Any idea why even after a successful registration and import Hive is showing empty results.

    Here is the tail end of the log that it produces
    14/07/21 00:30:43 INFO hive.metastore: Trying to connect to metastore with URI thrift://namenode.x.com:9083
    14/07/21 00:30:43 INFO hive.metastore: Connected to metastore.
    14/07/21 00:30:43 INFO session.SessionState: No Tez session required at this point. hive.execution.engine=mr.
    14/07/21 00:30:43 INFO log.PerfLogger: <PERFLOG method=Driver.execute from=org.apache.hadoop.hive.ql.Driver>
    14/07/21 00:30:43 INFO ql.Driver: Starting command: SELECT * FROM default.nyse_stocks
    14/07/21 00:30:43 INFO impl.TimelineClientImpl: Timeline service address: http://namenode.x.com:8188/ws/v1/timeline/
    14/07/21 00:30:43 INFO hooks.ATSHook: Created ATS Hook
    14/07/21 00:30:43 INFO log.PerfLogger: <PERFLOG method=PreHook.org.apache.hadoop.hive.ql.hooks.ATSHook from=org.apache.hadoop.hive.ql.Driver>
    14/07/21 00:30:43 INFO log.PerfLogger: </PERFLOG method=PreHook.org.apache.hadoop.hive.ql.hooks.ATSHook start=1405927843629 end=1405927843629 duration=0 from=org.apache.hadoop.hive.ql.Driver>
    14/07/21 00:30:43 INFO log.PerfLogger: </PERFLOG method=TimeToSubmit start=1405927843391 end=1405927843629 duration=238 from=org.apache.hadoop.hive.ql.Driver>
    14/07/21 00:30:43 INFO log.PerfLogger: <PERFLOG method=runTasks from=org.apache.hadoop.hive.ql.Driver>
    14/07/21 00:30:43 INFO log.PerfLogger: </PERFLOG method=runTasks start=1405927843629 end=1405927843629 duration=0 from=org.apache.hadoop.hive.ql.Driver>
    14/07/21 00:30:43 INFO impl.TimelineClientImpl: Timeline service address: http://namenode.x.com:8188/ws/v1/timeline/
    14/07/21 00:30:43 INFO hooks.ATSHook: Created ATS Hook
    14/07/21 00:30:43 INFO log.PerfLogger: <PERFLOG method=PostHook.org.apache.hadoop.hive.ql.hooks.ATSHook from=org.apache.hadoop.hive.ql.Driver>
    14/07/21 00:30:43 INFO log.PerfLogger: </PERFLOG method=PostHook.org.apache.hadoop.hive.ql.hooks.ATSHook start=1405927843693 end=1405927843694 duration=1 from=org.apache.hadoop.hive.ql.Driver>
    14/07/21 00:30:43 INFO log.PerfLogger: </PERFLOG method=Driver.execute start=1405927843560 end=1405927843694 duration=134 from=org.apache.hadoop.hive.ql.Driver>
    OK
    14/07/21 00:30:43 INFO ql.Driver: OK
    14/07/21 00:30:44 INFO session.SessionState: No Tez session required at this point. hive.execution.engine=mr.

You must be logged in to reply to this topic.