Cloudera Community
ccshih
user rank
Explorer
My Accepted Solutions
Show All

Re: Anyone successfully run an impala script?

by Explorer in Support Questions
‎09-02-2013 05:56 AM
‎09-02-2013 05:56 AM
Finally, I found a workaroud.   I wrote a python script which reads all statements from the script and slowly feeds each statement into "impala-shell -q". ... View more

Anyone successfully run an impala script?

by Explorer in Support Questions
‎09-01-2013 04:32 AM
‎09-01-2013 04:32 AM
Hi,   I would like to run a script (~200 lines) but have problems.   If I manually run each statement in the script, it is mostly fine. But if I use -f option to run this script in command line, it fails after 5~10 statement and shows the following error message:            ERROR: MetaException: javax.jdo.JDOObjectNotFoundException: No such database row        FailedObject:6[OID]org.apache.hadoop.hive.metastore.model.MDatabase        NestedThrowables:        org.datanucleus.exceptions.NucleusObjectNotFoundException: No such database row   Sometimes, this problem occurs in impala shell. But I can easily solve this problem by running the same statement again. However, I have no idea how to solve this problem in script mode.   Based on the above observation, I think I can mitigate this problem by  leaving some buffer time between statement executions. Or Maybe I can change configurations?   I am using Impala 1.0.1. (Actually in this VM: http://4zoas.com/cloudera-ccp-data-science-vm1-cdh4.3f-vmware.zip)   Any ideas would be greatly appreciated.   ... View more
Contact Me
Online
Offline
Last Visited
‎10-28-2013 04:27 AM
Community Statistics
Member Since ‎08-11-2013 08:14 AM
Last Visited ‎10-28-2013 04:27 AM
Posts 4