The Hortonworks Community Connection is now live. A completely rebuilt Q&A forum, Knowledge Base, Code Hub and more, backed by the experts in the industry.

You will be redirected here in 10 seconds. If your are not redirected, click here to visit the new site.

The legacy Hortonworks Forum is now closed. You can view a read-only version of the former site by clicking here. The site will be taken offline on January 31,2016

Hortonworks Sandbox Forum

BeeswaxException when creating table from twitter API

  • #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/”, 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/”, 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 does not exist)\n\tat org.apache.hadoop.hive.ql.metadata.Table.getDeserializerFromMetaStore(\n\tat org.apache.hadoop.hive.ql.metadata.Table.getDeserializer(\n\tat org.apache.hadoop.hive.ql.metadata.Table.getCols(\n\tat org.apache.hadoop.hive.ql.metadata.Table.checkValidity(\n\tat org.apache.hadoop.hive.ql.metadata.Hive.getTable(\n\tat org.apache.hadoop.hive.ql.metadata.Hive.getTable(\n\tat org.apache.hadoop.hive.ql.exec.DDLTask.showTableStatus(\n\tat org.apache.hadoop.hive.ql.exec.DDLTask.execute(\n\tat org.apache.hadoop.hive.ql.exec.Task.executeTask(\n\tat org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(\n\tat
    and other tables could not be established also.
    what can I do to create a table?

  • Author
  • #44995
    Cheryle Custer


    Which version of Sandbox are you using?
    Where are you pulling the Sentiment Tutorial from? Are you pulling the tutorial from here:

    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.

    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?

    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 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.




    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

    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,

    Vikas Thakur

    Hi Cheryle Custer,

    As per your last comment on this topic, you people were working on updating the Sentiment tutorial to work with sandbox 2.0 (, Can you please let us know when this tutorial will be working with 2.1 version of sandbox.

    Vikas Thakur

The forum ‘Hortonworks Sandbox’ is closed to new topics and replies.

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

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.