Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1455#discussion_r171032164
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -3499,6 +3499,152 @@ CREATE TABLE t1 (c1 int not null primary key, c2
char(50));
CREATE TABLE t2 (c1 int, c2 char (50) UPSHIFT NOT NULL) AS SELECT * FROM
t1;
```
+<<<
+[[create_external_table_examples]]
+==== Examples of CREATE EXTERNAL TABLE
+* This example compares the execution time of using external table and not
using external table when reading hive tables.
+
+** This is the definition of the table _customer_address1_ which has a
trafodion external table.
++
+```
+/* Hive DDL */
+
+CREATE TABLE HIVE.TPCDS_SF1000_ORC.customer_address1
+ (
+ CA_ADDRESS_SK int
+ , CA_ADDRESS_ID string
+ , CA_STREET_NUMBER string
+ , CA_STREET_NAME string
+ , CA_STREET_TYPE string
+ , CA_SUITE_NUMBER string
+ , CA_CITY string
+ , CA_COUNTY string
+ , CA_STATE string
+ , CA_ZIP string
+ , CA_COUNTRY string
+ , CA_GMT_OFFSET float
+ , CA_LOCATION_TYPE string
+ )
+ stored as orc
--- End diff --
My understanding is that the support in Trafodion for Hive ORC files is
incomplete and at best experimental at this point. I'm not sure we should use
ORC in our examples until the feature is product quality.
---
