Hi All,   When I try to run a huge query at Impala that does a lot of aggregation & sorts, it throws up with the following error. The error is vague and of not much help. Our cluster has 32 impala daemons and all the nodes have been configured with 8 disks of 4TB each. We defined scratch directories on all the disks/nodes in Cloudera Manager. I tried looking at the logs as indicated in the error message but I couldn't find anything useful.    Could not create files in any configured scratch directories (--scratch_dirs=) on backend 'data405.prod.com:22000'. See logs for previous errors that may have prevented creating or writing scratch files.   Version of impala: 2.12.0-cdh5.15.0     Any pointers would be greatly helpful.   Thanks, Ravi ... View more

  Hi,   A column in my table has an unix time in milliseconds. When I am trying to use from_unixtime() it is returning me null. In the documentation its mentioned that from_unixtime() handles only unix time in seconds. Any specific problem handling milliseconds?    select from_unixtime(1513895588243,"yyyy-MM-dd HH:mm:ss.SSSSSS"); Result> from_unixtime(1513895588243, 'yyyy-mm-dd hh:mm:ss.ssssss') NULL I am expecting '2017-12-21 22:33:08.243000000'   I wrote below query which would give me the result as expected above,   select 1513895588243, cast(concat(cast(from_unixtime(CAST(1513895588243/1000 as BIGINT), 'yyyy-MM-dd HH:mm:ss') as String),'.',substr(cast(1513895588243 as String), 11, 3)) as timestamp); Result: 1513895588243 2017-12-21 22:33:08.243000000   But, the above query is not an efficient way. Is there any efficient workaround for this? ... View more