Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/140#discussion_r42891264
--- Diff: core/sql/regress/hive/EXPECTED020 ---
@@ -132,24 +147,25 @@ S_STORE_SK (EXPR)
--- 1 row(s) selected.
>>
>>-- explain of join between 2 ORC tables
->>explain options 'f' select x.s_suite_number, y.s_street_name
+>>prepare XX from select x.s_suite_number, y.s_street_name
+> from hive.hive.store_orc x, hive.hive.store_orc y
+> where x.s_store_sk = y.s_store_sk;
-LC RC OP OPERATOR OPT DESCRIPTION CARD
----- ---- ---- -------------------- -------- --------------------
---------
+--- SQL command prepared.
+>>execute explainIt;
-3 . 4 root
8.17E+004
-2 1 3 hybrid_hash_join
8.17E+004
-. . 2 hive_scan STORE_ORC
4.08E+003
-. . 1 hive_scan STORE_ORC
4.08E+003
+S OPERATOR LC RC TAB_NAME
+-- ---------------- -- -- ----------
---- SQL operation complete.
+04 ROOT 3 ?
+03 HYBRID_HASH_JOIN 2 1
+02 HIVE_SCAN ? ? .STORE_ORC
--- End diff --
Did you want the dot in front of the table name? (possible off-by-one error
in the explainIt query text?) Can fix it later if desired.
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
