Hi,
I am getting error when I creating the CSV files
The part of the query throwing error is as below, the input data comes in
unix time format
 CAST(FROM_UNIXTIME(t.`timestamp`/1000) AS TIMESTAMP) AS `datetime`
Apache Drill
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
IllegalArgumentException: Invalid format: "2018-06-24T12:00:00.000-05:00"
is malformed at "T12:00:00.000-05:00" Fragment 1:0 [Error Id:
e43e9948-bc80-4485-b436-62bc57b1327f on usazprdmapr-dn2.am.jllnet.com:31010]
whereas with the same query when I create parquet files , I am able to read
and no error being thrown :

 CAST(FROM_UNIXTIME(t.`timestamp`/1000) AS TIMESTAMP) AS `datetime`

I can view the results too :

Appreciate the help !

Thanks,
Divya
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB