Hi, There is no screenshot in this mail. Please upload it to Google Drive and share here. Also what do you mean DateTimeOffset type? There is no DateTimeOffset logical Date/Time datatype in parquet [1]. Please use "parquet-tools" to define the schema of your parquet file [2].
[1] https://github.com/apache/parquet-format/blob/master/LogicalTypes.md#datetime-types [2] https://github.com/apache/parquet-mr/tree/master/parquet-tools#build On Thu, Sep 20, 2018 at 8:55 AM chen xinyi <[email protected]> wrote: > Hi, > > > Recently, I've encountered issue to query table with parquet file, there > is column with DateTimeOffset type, > > but apache drill couldn't read DateTimeOffset as well, see below > screenshot, I tried 'cast', 'convert_to' and other functions , neither > works. > > > Do you any plan to support DateTimeOffset with parquet? > > > > > Thanks! > > Simon >
