Hortonworks Sandbox Forum

Error in Beeswax

  • #51550
    Aleksandar Sargic
    Participant

    Following the tutorial, open up query editor and try to execute a simple query “Select * from nyse_stocks”. I receive following error: “Error occurred executing hive query: Unknown exception.”. Here is the log:

    [15/Apr/2014 08:27:12 +0000] access WARNING 10.0.0.24 hue – “GET /logs HTTP/1.0″
    [15/Apr/2014 08:26:55 +0000] access DEBUG 10.0.0.24 hue – “GET /static/ext/js/fileuploader.js HTTP/1.0″
    [15/Apr/2014 08:26:55 +0000] access DEBUG 10.0.0.24 hue – “GET /static/js/hue_common_header.js HTTP/1.0″
    [15/Apr/2014 08:26:55 +0000] access DEBUG 10.0.0.24 hue – “GET /static/ext/js/bootstrap.min.js HTTP/1.0″
    [15/Apr/2014 08:26:55 +0000] access DEBUG 10.0.0.24 hue – “GET /static/js/Source/jHue/jquery.datatables.sorting.js HTTP/1.0″
    [15/Apr/2014 08:26:55 +0000] access DEBUG 10.0.0.24 hue – “GET /static/ext/js/jquery/plugins/jquery.dataTables.1.8.2.min.js HTTP/1.0″
    [15/Apr/2014 08:26:55 +0000] access DEBUG 10.0.0.24 hue – “GET /static/ext/js/jquery/plugins/jquery.simpleplaceholder.js HTTP/1.0″
    [15/Apr/2014 08:26:55 +0000] access DEBUG 10.0.0.24 hue – “GET /static/ext/js/jquery/plugins/jquery.cookie.js HTTP/1.0″
    [15/Apr/2014 08:26:55 +0000] access DEBUG 10.0.0.24 hue – “GET /static/js/Source/jHue/jquery.tableextender.js HTTP/1.0″
    [15/Apr/2014 08:26:55 +0000] access DEBUG 10.0.0.24 hue – “GET /static/js/Source/jHue/jquery.tablescroller.js HTTP/1.0″
    [15/Apr/2014 08:26:55 +0000] access DEBUG 10.0.0.24 hue – “GET /static/js/Source/jHue/jquery.notify.js HTTP/1.0″
    [15/Apr/2014 08:26:55 +0000] access DEBUG 10.0.0.24 hue – “GET /static/js/Source/jHue/jquery.rowselector.js HTTP/1.0″
    [15/Apr/2014 08:26:55 +0000] access DEBUG 10.0.0.24 hue – “GET /static/js/Source/jHue/jquery.alert.js HTTP/1.0″
    [15/Apr/2014 08:26:55 +0000] access DEBUG 10.0.0.24 hue – “GET /static/js/Source/jHue/jquery.selector.js HTTP/1.0″
    [15/Apr/2014 08:26:55 +0000] access DEBUG 10.0.0.24 hue – “GET /static/ext/js/jquery/jquery-1.8.1.min.js HTTP/1.0″
    [15/Apr/2014 08:26:55 +0000] access DEBUG 10.0.0.24 hue – “GET /static/js/Source/jHue/jquery.filechooser.js HTTP/1.0″
    [15/Apr/2014 08:26:55 +0000] middleware INFO Processing exception: Error occurred executing hive query: Unknown exception.: Traceback (most recent call last):
    File “/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.2.3-py2.6.egg/django/core/handlers/base.py”, line 100, in get_response
    response = callback(request, *callback_args, **callback_kwargs)
    File “/usr/lib/hue/apps/beeswax/src/beeswax/views.py”, line 70, in index
    return execute_query(request)
    File “/usr/lib/hue/apps/beeswax/src/beeswax/views.py”, line 554, in execute_query
    return execute_directly(request, query, query_server, design, on_success_url=on_success_url, download=download)
    File “/usr/lib/hue/apps/beeswax/src/beeswax/views.py”, line 1242, in execute_directly
    raise PopupException(_(‘Error occurre

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #51566
    Aleksandar Sargic
    Participant

    Figured it out. The tutorial syntax is apparently wrong. I went to HCatalog and browsed data which reveals the query in a separate tab.

    This is the proper syntax: SELECT * FROM default.nyse_stock. Notice that database.table_name are enclosed in single quotation marks. Not as surprised about tutorial (we all make mistakes), but error handling in Beeswax for simple syntax is surprisingly sub-par.

    #51567
    Aleksandar Sargic
    Participant

    SELECT * FROM 'default.nyse_stock'

You must be to reply to this topic. | Create Account

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.