Hi Dileep,
Have tried to se the following values in hive and run the query again. More
info why the query may fail in the following link :
https://cwiki.apache.org/Hive/statsdev.html
set hive.stats.autogather=false;
As well as ;
set hive.stats.dbclass=jdbc:derby;
set
hive.stats.dbconnect
Thanks for your attention !
No only one hive process is running and thing that bother me is smaller
query runs till completion which I invoke the same way. It is using embeded
db if that is the problem I can change it to external DB but as my smaller
query runs fine I thought this should be OK.
O
Do you have more than one hive process running? It looks like you're using
Derby, which only supports one process at a time. Also, you have to start
Hive from the same directory every time, where the metastore "database" is
written, unless you edit the JDBC connection property in the Hive config
fi
