Has anybody this issue between CSV and parquet files ? Really appreciate the help !
On Mon, 2 Jul 2018 at 17:51, Divya Gehlot <[email protected]> wrote: > 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 > >
