Home Forums Hortonworks Sandbox BeeswaxException when creating table from twitter API


This topic contains 5 replies, has 4 voices, and was last updated by  Rahul Dhond 4 months ago.

  • Creator
  • #44971

    Wenzhao Li

    I followed the tutorial 13 in Windows 7:


    when I went to step 4 to browse data in tweets_raw, I recieved following:
    Could not read table
    BeeswaxException(handle=QueryHandle(log_context=’ae18ae74-518f-400b-b4b0-d399ed78e194′, id=’ae18ae74-518f-400b-b4b0-d399ed78e194′), log_context=’ae18ae74-518f-400b-b4b0-d399ed78e194′, SQLState=’ ‘, _message=None, errorCode=0)

    and when I click on the “tweets_raw”, I recieved:
    Error getting table description

    Traceback (most recent call last): File “/usr/lib/hue/apps/hcatalog/src/hcatalog/views.py”, line 145, in describe_table table_desc_extended = HCatClient(request.user.username).describe_table_extended(table, db=database) File “/usr/lib/hue/apps/hcatalog/src/hcatalog/hcat_client.py”, line 143, in describe_table_extended raise Exception(error) Exception: Could not get table description (extended): {“errorDetail”:”java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException SerDe org.openx.data.jsonserde.JsonSerDe does not exist)\n\tat org.apache.hadoop.hive.ql.metadata.Table.getDeserializerFromMetaStore(Table.java:274)\n\tat org.apache.hadoop.hive.ql.metadata.Table.getDeserializer(Table.java:265)\n\tat org.apache.hadoop.hive.ql.metadata.Table.getCols(Table.java:597)\n\tat org.apache.hadoop.hive.ql.metadata.Table.checkValidity(Table.java:170)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:991)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:924)\n\tat org.apache.hadoop.hive.ql.exec.DDLTask.showTableStatus(DDLTask.java:2689)\n\tat org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:343)\n\tat org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:151)\n\tat org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:65)\n\tat
    and other tables could not be established also.
    what can I do to create a table?

Viewing 5 replies - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.

  • Author
  • #45524

    Rahul Dhond

    Hi Rajesh,
    I am using Sandbox 1.3. The root of the problem was the .jar file (the one that I mentioned in my earlier reply). Once I copied that to /root, other things fell in place and the above error also went away.
    thanks & regards,



    I think currently tutorial is not supported for Sandbox 2.0 in case you are using this version.

    Rajesh K Singh
    Aditi Technologies Ltd.


    Rahul Dhond

    I am doing the same tutorial (13, Sentiment data) and using Sandbox version 1.3. When I run hiveddl.sql in hive, I get
    Could not read table

    BeeswaxException(errorCode=0, log_context=’cf02f84a-f92e-4091-951e-6438752ad04c’, message=’OK\nFAILED: RuntimeException MetaException(message:org.apache.hadoop.hive.serde2.SerDeException SerDe org.openx.data.jsonserde.JsonSerDe does not exist)\n’, SQLState=’ ‘, handle=QueryHandle(log_context=’cf02f84a-f92e-4091-951e-6438752ad04c’, id=’cf02f84a-f92e-4091-951e-6438752ad04c’))

    Is the ‘JSON Serde does not exist’ error because it cannot find it? I have it copied to my /root on CentOS. Should I be moving it to HDFS?

    Also, the extracted files for this tutorial contain hive_raw.sql and some other files that dont seem to be used at all for the tutorial. Is that correct (or do they need to be used to run this tutorial successfully)? Could you please let me know? Thanks.



    Wenzhao Li

    I do use the the 2.0 version of the Sandbox, so what I can do? can I download the 1.3 version?


    Cheryle Custer


    Which version of Sandbox are you using?
    Where are you pulling the Sentiment Tutorial from? Are you pulling the tutorial from here: http://hortonworks.com/hadoop-tutorial/how-to-refine-and-visualize-sentiment-data/?

    Note that the Sentiment tutorial on the website only works with the 1.3 version of the Sandbox. We are working to update it to work with the 2.0 version of the Sandbox.

Viewing 5 replies - 1 through 5 (of 5 total)