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

Hive / HCatalog Forum

BeeswaxException when creating table from twitter API

  • #44961
    Wenzhao Li
    Member

    I followed the tutorial 13 in Windows 7:
    http://hortonworks.com/hadoop-tutorial/how-to-refine-and-visualize-sentiment-data/
    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?

  • Author
    Replies
  • #45048
    Rahul Dhond
    Participant

    Hi WenZhao (or anyone else on this forum who can help),
    I am stuck at step 4 too. I am getting a Json Serde error of ‘file not found’. Maybe you have done that part correctly, so I want to ask you this. Where is the json-serde-1.1.6-SNAPSHOT-jar-with-dependencies file supposed to go? Do you keep it on /root ? I believe it goes in $/HIVE_HOME/lib..I have tried both but it didn’t work. Could you please let me know?

    By the way, I am using Sandbox 1.3.

    thanks & regards
    Rahul

    #45520

    Hi Rahul,

    It seems they have missed to add one more point in the tutorial.
    Please copy “json-serde-1.1.6-SNAPSHOT-jar-with-dependencies.jar” files also at the root folder where you have copied hiveddl.sql file.

    After you are done copying jar file at the root folder RUN following command on VM Console.

    hive -f hiveddl.sql

    Thanks,
    Rajesh K Singh
    Aditi Technologies Pvt Limited.

The forum ‘Hive / HCatalog’ 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.