vikramahuja1001 commented on code in PR #6761:
URL: https://github.com/apache/hive/pull/6761#discussion_r3988474427


##########
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:
   Sure, will do.



-- 
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]

Reply via email to