devanbenz commented on code in PR #12466:
URL: https://github.com/apache/datafusion/pull/12466#discussion_r1768826117
##########
datafusion/sqllogictest/test_files/create_external_table.slt:
##########
@@ -228,3 +228,13 @@ OPTIONS (
format.delimiter '|',
has_header false,
compression gzip);
+
+# Create an external parquet table and infer schema to order by
+
+# query should succeed
+statement ok
+CREATE EXTERNAL TABLE t STORED AS parquet LOCATION
'../../parquet-testing/data/alltypes_plain.parquet' WITH ORDER (id);
Review Comment:
Can do
##########
datafusion/sqllogictest/test_files/create_external_table.slt:
##########
@@ -228,3 +228,13 @@ OPTIONS (
format.delimiter '|',
has_header false,
compression gzip);
+
+# Create an external parquet table and infer schema to order by
+
+# query should succeed
+statement ok
+CREATE EXTERNAL TABLE t STORED AS parquet LOCATION
'../../parquet-testing/data/alltypes_plain.parquet' WITH ORDER (id);
+
+# query should fail with bad column
+statement error
+CREATE EXTERNAL TABLE t STORED AS parquet LOCATION
'../../parquet-testing/data/alltypes_plain.parquet' WITH ORDER (foo);
Review Comment:
👍
--
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]
