vikramahuja1001 commented on code in PR #6761: URL: https://github.com/apache/hive/pull/6761#discussion_r3987084173
########## ql/src/test/queries/clientpositive/timestampz_with_file_formats.q: ########## @@ -0,0 +1,19 @@ +CREATE TABLE timestampltz_formats ( + formatid string, + tsval timestamp with local time zone +) +ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'; + +LOAD DATA LOCAL INPATH '../../data/files/timestamps_mixed_formats.txt' overwrite into table timestampltz_formats; + +SELECT * FROM timestampltz_formats; + +CREATE TABLE timestampltz_orc_format ( + formatid string, + tsval timestamp with local time zone +) +stored as orc; + +insert into timestampltz_orc_format select * from timestampltz_formats; + +SELECT * FROM timestampltz_orc_format; Review Comment: Yes rightly pointed, ORDER BY clause is giving an exception. To fix that will require a lot of changes, which are separate from the scope of this PR. I have raised a follow up JIRA and will work on that as well, hope that's fine. JIRA ID: https://issues.apache.org/jira/browse/HIVE-30042 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
