Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hue 3.9.0 CDH5.7 Impala Query Editor broken

Highlighted

Hue 3.9.0 CDH5.7 Impala Query Editor broken

New Contributor

Hi Guys,

 

We recently upgraded CDH5.5.1 to CDH5.7. Hue version installed 3.9.0. After upgrade Hue Impala Query Editior stopped working. Impala is functioning fine via impala-shell.

 

Following error appears in hue/error.log

 

[20/May/2016 12:56:52 -0700] api ERROR failed to load the HBase clusters
Traceback (most recent call last):
File "/usr/lib/hue/apps/hbase/src/hbase/api.py", line 64, in getClusters
full_config = json.loads(conf.HBASE_CLUSTERS.get().replace("'", "\""))
File "/usr/lib64/python2.6/json/__init__.py", line 307, in loads
return _default_decoder.decode(s)
File "/usr/lib64/python2.6/json/decoder.py", line 319, in decode
obj, end = self.raw_decode(s, idx=_w(s, 0).end())
File "/usr/lib64/python2.6/json/decoder.py", line 338, in raw_decode
raise ValueError("No JSON object could be decoded")
ValueError: No JSON object could be decoded
[20/May/2016 12:56:54 -0700] conf ERROR No available Impalad to send queries to.
Traceback (most recent call last):
File "/usr/lib/hue/apps/impala/src/impala/conf.py", line 179, in config_validator
server.get_databases()
File "/usr/lib/hue/apps/beeswax/src/beeswax/server/dbms.py", line 149, in get_databases
databases = self.client.get_databases(schemaName=database_names)
File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 1079, in get_databases
return [table[col] for table in self._client.get_databases(schemaName)]
File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 666, in get_databases
return HiveServerTRowSet(results.results, schema.schema).cols((col,))
File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 199, in cols
cols = [rs.full_col(name) for name in col_names]
File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 227, in full_col
return HiveServerTColumnValue2(self.cols[pos]).val # Return the full column and its values
File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 246, in val
if self.column_value.stringVal:
AttributeError: TColumn instance has no attribute 'stringVal'

 

Any help appreciated.

 

Thanks,

Ashim

2 REPLIES 2

Re: Hue 3.9.0 CDH5.7 Impala Query Editor broken

The real error is

[20/May/2016 12:56:54 -0700] conf ERROR No available Impalad to send
queries to.
Traceback (most recent call last):
File "/usr/lib/hue/apps/impala/src/impala/conf.py", line 179, in
config_validator
server.get_databases()
File "/usr/lib/hue/apps/beeswax/src/beeswax/server/dbms.py", line 149, in
get_databases
databases = self.client.get_databases(schemaName=database_names)
File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py",
line 1079, in get_databases
return [table[col] for table in self._client.get_databases(schemaName)]
File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py",
line 666, in get_databases
return HiveServerTRowSet(results.results, schema.schema).cols((col,))
File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py",
line 199, in cols
cols = [rs.full_col(name) for name in col_names]
File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py",
line 227, in full_col
return HiveServerTColumnValue2(self.cols[pos]).val # Return the full column
and its values
File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py",
line 246, in val
if self.column_value.stringVal:
AttributeError: TColumn instance has no attribute 'stringVal'

but I never saw it before. Did the update happened normally? Did you do a
parcel install? Does the Hive editor work too?

Re: Hue 3.9.0 CDH5.7 Impala Query Editor broken

New Contributor

Thank you Romainr for your response.

 

> Did the update happened normally?

I did not see any errors during the installation.

 

Did you do a parcel install?

I grabbed all the CDH rpm package names and performed upgrade against it after stopping all CDH daemons. 

 

>  Does the Hive editor work too?

The hive editor via Hue is working fine.

 

Please let me know if you require any information.

 

Thanks,

Ashim