@iamfromsky as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.  ... View more

Hi there, is it dfs_datanode_data_dir_perm?   what's your previous value for it when it couldn't write?  ... View more

Later versions of hive have a "sys" DB that under the hood connects back to the hive metastore database (eg Postgres or whatever). and you can query that. Impala seems not to be able to see this sys db though.   There is also a "information_schema" DB with a smaller and cleaner subset but it points back to sys and also not visible from impala if you do a "show databases;"   You can use "show" statements in impala-shell but I'm not sure there is a DB to through SQL at via ODBC/JDBC.    Still looking for a way to do this in impala   ... View more

I too have the same scenario where in the column was decimal and updated to bigint, now getting error while querying the column.  the data type on the table and the parquet file are aligned.   Error: java.io.IOException: java.lang.ClassCastException: org.apache.hadoop.io.LongWritable cannot be cast to org.apache.hadoop.hive.serde2.io.HiveDecimalWritable (state=,code=0)   If you have already resolved the issue, much appreciate if you could let know what worked for you.    Thanks  Dinesh ... View more

Could you please let us know which documentation you are talking about? ... View more

hi @elkrish ,   Was this resolved ?? can u share if you found a solution for this issue ??   ... View more

So Presto now supports ACID tables, but only for Hive3. However, the subdirectory exception is from a configuration on the presto client side. In the hive.properties in presto's catalog directory, add "hive.recursive-directories=true" ... View more

Thanks, this really helps ... View more

How do I check if HS2 can reach port 2181? ... View more

No i cant view the result of this simple query   ... View more