Member since
08-10-2015
12
Posts
3
Kudos Received
0
Solutions
05-29-2019
06:35 AM
adding the schemas to the search path does the trick: ALTER DATABASE <database_name> SET search_path TO schema1,schema2,...;
... View more
05-28-2019
07:11 AM
Anybody found a solution for that?
... View more
04-05-2019
07:11 AM
Thanks for prompt answer!
... View more
04-05-2019
02:27 AM
Hi, I foun this error in HUE server each time I pick a query from query history in Hive Editor. Only if the query has NOT expired... Any idea, suggestion? 11:17:02 AM ERROR decorators Error running fetch_result_size
Traceback (most recent call last):
File "/opt/cloudera/parcels/CDH-6.1.0-1.cdh6.1.0.p0.770702/lib/hue/desktop/libs/notebook/src/notebook/decorators.py", line 97, in decorator
return func(*args, **kwargs)
File "/opt/cloudera/parcels/CDH-6.1.0-1.cdh6.1.0.p0.770702/lib/hue/desktop/libs/notebook/src/notebook/api.py", line 264, in fetch_result_size
response['result'] = get_api(request, snippet).fetch_result_size(notebook, snippet)
File "/opt/cloudera/parcels/CDH-6.1.0-1.cdh6.1.0.p0.770702/lib/hue/desktop/libs/notebook/src/notebook/connectors/hiveserver2.py", line 82, in decorator
return func(*args, **kwargs)
File "/opt/cloudera/parcels/CDH-6.1.0-1.cdh6.1.0.p0.770702/lib/hue/desktop/libs/notebook/src/notebook/connectors/hiveserver2.py", line 329, in fetch_result_size
raise QueryError(_('Result status is not available'))
QueryError
... View more
09-02-2018
01:14 AM
Hi, on all queries, even just 1 minute old ones... No other errors, just on hue server the decorators error...
... View more
08-10-2018
01:26 AM
1 Kudo
After upgrade to CDH 5.14 HUE server throws this error (is related to open non-exprired query. it only retrieve 100 records from the resulset): 10:23:01 AM ERROR decorators Error running <function fetch_result_size at 0x7f521d833230> Traceback (most recent call last): File "/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/desktop/libs/notebook/src/notebook/decorators.py", line 97, in decorator return func(*args, **kwargs) File "/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/desktop/libs/notebook/src/notebook/api.py", line 260, in fetch_result_size response['result'] = get_api(request, snippet).fetch_result_size(notebook, snippet) File "/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/desktop/libs/notebook/src/notebook/connectors/hiveserver2.py", line 82, in decorator return func(*args, **kwargs) File "/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/lib/hue/desktop/libs/notebook/src/notebook/connectors/hiveserver2.py", line 321, in fetch_result_size raise QueryError(_('Result status is not available')) QueryError
... View more
Labels:
06-05-2018
12:59 AM
In my case is for Hive queries. The firs time you run it it has the download button, but when you retrieve them from the Query History, the download results button has gone.
... View more
08-20-2015
03:27 AM
1 Kudo
Did you find the cause? Thanks!
... View more
08-12-2015
08:38 AM
Hi, running CDH5.4.3 cluster on Ubuntu 14.04. When it try to start Impala services I see this error. The impala ERR logg says: cat /var/log/impalad/impalad.ERROR Log file created at: 2015/08/10 12:07:06 Running on machine: filisteo5 Log line format: [IWEF]mmdd hh:mm:ss.uuuuuu threadid file:line] msg E0810 12:07:06.943514 3143 logging.cc:119] stderr will be logged to this file. E0810 12:07:12.488956 3143 impala-server.cc:230] ERROR: short-circuit local reads is disabled because - dfs.domain.socket.path is not configured. - dfs.client.read.shortcircuit is not enabled. ERROR: block location tracking is not properly enabled because - dfs.client.file-block-storage-locations.timeout.millis is too low. It should be at least 10 seconds. E0810 12:07:12.488999 3143 impala-server.cc:232] Aborting Impala Server startup due to improper configuration I've tried the "post-installation" steps form Impalq (the ones that are supossed to not to be needed with Cloudera Manager 5.4.x) and it did'nt work neither... Any idea? Thanks in Advance!
... View more
08-10-2015
05:52 AM
1 Kudo
This may be "brute force" but I solved with: sudo -u hdfs hadoop fs -chmod 777 /user then the health check for "Cloudera Manager Metastore Canary Test Database" worked fine...
... View more
08-10-2015
03:56 AM
Same error here with CDH 5.4.3 just installed with Cloudera Manager. I can't see any "hue" dir under "user" dir in HDFS... not sure if just creating it will solve it...
... View more
08-10-2015
03:46 AM
Hi, I'm using Cloudera Mamanger to setup a CDH5.4.3 cluster on Ubuntu 14.04. When it try to start Impala services I see this error: Deploying Client Configuration Successfully deployed all client configurations. Details Creating HDFS /tmp directory HDFS directory /tmp already exists. Details Creating Impala user directory Successfully created HDFS directory. Details Starting Impala Service Failed to execute command Start on service Impala Details The impala ERR logg says: cat /var/log/impalad/impalad.ERROR Log file created at: 2015/08/10 12:07:06 Running on machine: filisteo5 Log line format: [IWEF]mmdd hh:mm:ss.uuuuuu threadid file:line] msg E0810 12:07:06.943514 3143 logging.cc:119] stderr will be logged to this file. E0810 12:07:12.488956 3143 impala-server.cc:230] ERROR: short-circuit local reads is disabled because - dfs.domain.socket.path is not configured. - dfs.client.read.shortcircuit is not enabled. ERROR: block location tracking is not properly enabled because - dfs.client.file-block-storage-locations.timeout.millis is too low. It should be at least 10 seconds. E0810 12:07:12.488999 3143 impala-server.cc:232] Aborting Impala Server startup due to improper configuration I've tried th "post-installation" steps form Impalqa (the iones that are supossed to not to be needed with Cloudera Manager) and it did'nt work neither... Any idea? Thanks in Advance!
... View more