Error while trying to 'Preview sample data' .

25 views
Skip to first unread message

Ram konchada

unread,
Aug 8, 2016, 1:44:31 PM8/8/16
to Hue-Users
I am trying to preview sample data and I get the following error in the log.  Any ideas on how to fix this problem please?  HUE Version is 3.9.0 .

Also, please find the hive settings from hue.ini file.



[08/Aug/2016 17:36:27 +0000] middleware   INFO     Processing exception: Problem accessing table metadata: Traceback (most recent call last):
  File "/usr/local/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/core/handlers/base.py", line 112, in get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/usr/local/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/transaction.py", line 371, in inner
    return func(*args, **kwargs)
  File "/usr/local/hue/apps/beeswax/src/beeswax/api.py", line 628, in describe_table
    raise PopupException(_('Problem accessing table metadata'), detail=e)
PopupException: Problem accessing table metadata

###########################################################################
# Settings to configure Beeswax with Hive
###########################################################################

[beeswax]

  # Host where HiveServer2 is running.
  # If Kerberos security is enabled, use fully-qualified domain name (FQDN).
  hive_server_host=xxxx.yyyy

  # Port where HiveServer2 Thrift server runs on.
  ## hive_server_port=10000

  # Hive configuration directory, where hive-site.xml is located
  hive_conf_dir=/etc/hive/conf

  # Timeout in seconds for thrift calls to Hive service
  ## server_conn_timeout=120

  # Choose whether to use the old GetLog() thrift call from before Hive 0.14 to retrieve the logs.
  # If false, use the FetchResults() thrift call from Hive 1.0 or more instead.
  ## use_get_log_api=false

  # Set a LIMIT clause when browsing a partitioned table.
  # A positive value will be set as the LIMIT. If 0 or negative, do not set any limit.
  ## browse_partitioned_table_limit=250

  # A limit to the number of rows that can be downloaded from a query.
  # A value of -1 means there will be no limit.
  # A maximum of 65,000 is applied to XLS downloads.
  ## download_row_limit=1000000

  # Hue will try to close the Hive query when the user leaves the editor page.
  # This will free all the query resources in HiveServer2, but also make its results inaccessible.
  ## close_queries=false

  # Thrift version to use when communicating with HiveServer2.
  # New column format is from version 7.
  ## thrift_version=7
  # Share saved queries with all users. If set to false, saved queries are
  # visible only to the owner and administrators.
  share_saved_queries=true

  [[ssl]]
    # Path to Certificate Authority certificates.
    ## cacerts=/etc/hue/cacerts.pem

    # Choose whether Hue should validate certificates received from the server.
    ## validate=true



Romain Rigaux

unread,
Aug 9, 2016, 11:49:53 AM8/9/16
to Ram konchada, Hue-Users
Is Hive working properly?

Can you so 'SHOW TABLES', 'DESCRIBE TABLE xxx' ?

--
You received this message because you are subscribed to the Google Groups "Hue-Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hue-user+unsubscribe@cloudera.org.

Ram konchada

unread,
Aug 9, 2016, 12:02:14 PM8/9/16
to Romain Rigaux, Hue-Users

Yes. Hive is working properly with queries and all.  Show tables and describe works just fine.

 

Sent from my Windows 10 phone

--

To unsubscribe from this group and stop receiving emails from it, send an email to hue-user+u...@cloudera.org.

 

 

Romain Rigaux

unread,
Aug 9, 2016, 12:13:22 PM8/9/16
to Ram konchada, Hue-Users
Did you do the describe formatted on this table?

--

To unsubscribe from this group and stop receiving emails from it, send an email to hue-user+unsubscribe@cloudera.org.

 

 


Ram konchada

unread,
Aug 9, 2016, 12:18:25 PM8/9/16
to Romain Rigaux, Hue-Users

Yes I did and it works.

To unsubscribe from this group and stop receiving emails from it, send an email to hue-user+u...@cloudera.org.

 

 

 

 

Reply all
Reply to author
Forward
0 new messages