Home Forums Hortonworks Sandbox Error in Beeswax

Tagged: ,

This topic contains 2 replies, has 1 voice, and was last updated by  Aleksandar Sargic 4 months, 2 weeks ago.

  • Creator
    Topic
  • #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

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

You must be logged in to reply to this topic.

  • Author
    Replies
  • #51567

    Aleksandar Sargic
    Participant

    SELECT * FROM 'default.nyse_stock'

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

    Collapse
Viewing 2 replies - 1 through 2 (of 2 total)