Support Questions

Find answers, ask questions, and share your expertise

CM 4.6 -> 4.6.3 + Impala 1.0.1 -> 1.1 upgrade. HUE "Refresh button" doesn't work

avatar
Expert Contributor

Impala "select version()" does return correct verison: 1.1.1

But button "REFRESH" doesn't work.

 

Here is HUE log:

 


Impala, HUE services have been restarted. We are using CDH 4.3

CDH, Impala installed using parcels.

 

20:30:14.000ERRORthrift_util
Thrift saw exception (this may be expected).
Traceback (most recent call last):
File "/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/share/hue/desktop/core/src/desktop/lib/thrift_util.py", line 338, in wrapper
ret = res(*args, **kwargs)
File "/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/share/hue/apps/impala/src/impala/../../gen-py/ImpalaService/ImpalaHiveServer2Service.py", line 39, in ResetCatalog
return self.recv_ResetCatalog()
File "/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/share/hue/apps/impala/src/impala/../../gen-py/ImpalaService/ImpalaHiveServer2Service.py", line 54, in recv_ResetCatalog
raise x
TApplicationException: Invalid method name: 'ResetCatalog'

 

 

1 ACCEPTED SOLUTION

avatar
Expert Contributor
4 REPLIES 4

avatar
Expert Contributor

Could be a Hue bug as similar exceptions have been fixed as a bug. Please submit a bug.

 

https://issues.cloudera.org/browse/HUE-1271

avatar
Super Guru
After Impala 1.1 please instead either type one of these queries:

1. invalidate metadata
2. refresh MY_TABLE_NAME

avatar
Expert Contributor

Doesn't help

 

Server version: impalad version 1.1 RELEASE (build 5e15fcacc48ec4ea65e8aa76362cb3ec9be26f13)
Welcome to the Impala shell. Press TAB twice to see a list of available commands.

Copyright (c) 2012 Cloudera, Inc. All rights reserved.

(Shell build version: Impala Shell v1.1 (5e15fca) built on Sun Jul 21 15:51:04 PDT 2013)

 

[localhost:21000] > invalidate metadata;
Query: invalidate metadata
Query finished, fetching results ...

 

[localhost:21000] > refresh zone_dimensions;
Query: refresh zone_dimensions
Query finished, fetching results ...

Returned 0 row(s) in 0.36s
[localhost:21000] > select * from zone_dimensions limit 10;
Query: select * from zone_dimensions limit 10
ERROR: AnalysisException: Failed to load metadata for table: default.zone_dimensions
CAUSED BY: TableLoadingException: Failed to load metadata for table: zone_dimensions
CAUSED BY: NullPointerException: null

avatar
Expert Contributor

It was a problem with bug with avro schema.

https://issues.cloudera.org/browse/IMPALA-538