Alicia Ying Shu created PHOENIX-2351:
----------------------------------------
Summary: Phoenix query table alias name is not coming the output
xml file
Key: PHOENIX-2351
URL: https://issues.apache.org/jira/browse/PHOENIX-2351
Project: Phoenix
Issue Type: Bug
Reporter: Alicia Ying Shu
Phoenix query table alias name is not coming the output xml file.
2015-09-18 00:51:10,440|main|INFO|16074|140258496624448|MainThread|RUNNING TEST
"test_SortMergeJoin" at location
"tests/phoenix/JoinTesting/test_JoinTesting.py" at line number "107"
2015-09-18
00:51:10,441|beaver.component.phoenix|INFO|16074|140258496624448|MainThread|RUNNING
Command in input file: !outputformat xmlattr
SELECT /*+ SORTED_MERGE_JOIN */ * FROM LARGE_TABLE AS L INNER JOIN
GIGANTIC_TABLE AS G ON L.UNSIG_ID=G.BIG_ID LIMIT 10000;
2015-09-18
00:51:10,442|beaver.machine|INFO|16074|140258496624448|MainThread|RUNNING:
./sqlline.py os-u14-qubazs-phoenix-2.novalocal:2181:/hbase-secure
/grid/0/hadoopqe/artifacts/phoenixSQLQuery/inputFile.txt
2015-09-18
00:51:10,771|beaver.machine|INFO|16074|140258496624448|MainThread|[1;34mSetting
property: [isolation, TRANSACTION_READ_COMMITTED][m
2015-09-18
00:51:10,772|beaver.machine|INFO|16074|140258496624448|MainThread|[1;34mSetting
property: [run, /grid/0/hadoopqe/artifacts/phoenixSQLQuery/inputFile.txt][m
2015-09-18
00:51:10,772|beaver.machine|INFO|16074|140258496624448|MainThread|[1;34missuing:
!connect jdbc:phoenix:os-u14-qubazs-phoenix-2.novalocal:2181:/hbase-secure
none none org.apache.phoenix.jdbc.PhoenixDriver[m
2015-09-18
00:51:10,775|beaver.machine|INFO|16074|140258496624448|MainThread|[1;34mConnecting
to jdbc:phoenix:os-u14-qubazs-phoenix-2.novalocal:2181:/hbase-secure[m
2015-09-18
00:51:12,280|beaver.machine|INFO|16074|140258496624448|MainThread|15/09/18
00:51:12 WARN util.NativeCodeLoader: Unable to load native-hadoop library for
your platform... using builtin-java classes where applicable
...
2015-09-18 00:51:16,810|beaver.machine|INFO|16074|140258496624448|MainThread|at
sqlline.SqlLine.start(SqlLine.java:398)
2015-09-18 00:51:16,811|beaver.machine|INFO|16074|140258496624448|MainThread|at
sqlline.SqlLine.main(SqlLine.java:292)
2015-09-18
00:51:16,813|beaver.machine|INFO|16074|140258496624448|MainThread|1/2
!outputformat xmlattr
2015-09-18
00:51:16,814|beaver.machine|INFO|16074|140258496624448|MainThread|2/2
SELECT /*+ SORTED_MERGE_JOIN */ * FROM LARGE_TABLE AS L INNER JOIN
GIGANTIC_TABLE AS G ON L.UNSIG_ID=G.BIG_ID LIMIT 10000;
2015-09-18
00:52:00,725|beaver.machine|INFO|16074|140258496624448|MainThread|<resultset>
2015-09-18
00:52:00,781|beaver.machine|INFO|16074|140258496624448|MainThread|<result
ID="0" UNSIG_ID="0" BIG_ID="0" UNSIG_LONG_ID="0" TINY_ID="0" UNSIG_TINY_ID="0"
SMALL_ID="0" UNSIG_SMALL_ID="0" FLOAT_ID="0.5" UNSIG_FLOAT_ID="0.25"
DOUBLE_ID="0.125" UNSIG_DOUBLE_ID="5.97468982575" DECIMAL_ID="3.7315801827"
BOOLEAN_ID="false" TIME_ID="1994-05-08 04:39:54.000" DATE_ID="2069-03-06
05:18:23.000" TIMESTAMP_ID="2084-03-28 19:06:50.000" UNSIG_TIME_ID="2095-12-19
18:51:20.000" UNSIG_DATE_ID="1986-08-07 00:36:56.000"
UNSIG_TIMESTAMP_ID="2043-03-31 07:06:57.000" VARCHAR_ID="'Sample text'"
CHAR_ID="'a'" BINARY_ID="null" VARBINARY_ID="null" ID="0" UNSIG_ID="0"
BIG_ID="0" UNSIG_LONG_ID="0" TINY_ID="0" UNSIG_TINY_ID="0" SMALL_ID="0"
UNSIG_SMALL_ID="0" FLOAT_ID="0.5" UNSIG_FLOAT_ID="0.25" DOUBLE_ID="0.125"
UNSIG_DOUBLE_ID="5.65960066255" DECIMAL_ID="5.65588225357" BOOLEAN_ID="false"
TIME_ID="2047-09-21 17:36:52.000" DATE_ID="2008-01-01 13:24:29.000"
TIMESTAMP_ID="2037-12-31 01:11:54.000" UNSIG_TIME_ID="2035-12-10 21:08:24.000"
UNSIG_DATE_ID="2000-09-15 08:42:44.000" UNSIG_TIMESTAMP_ID="2026-03-21
08:17:27.000" VARCHAR_ID="'Sample text'" CHAR_ID="'a'" BINARY_ID="null"
VARBINARY_ID="null"/>
2015-09-18
00:52:00,788|beaver.machine|INFO|16074|140258496624448|MainThread|<result
ID="0" UNSIG_ID="0" BIG_ID="0" UNSIG_LONG_ID="0" TINY_ID="0" UNSIG_TINY_ID="0"
SMALL_ID="0" UNSIG_SMALL_ID="0" FLOAT_ID="0.5" UNSIG_FLOAT_ID="0.25"
DOUBLE_ID="0.125" UNSIG_DOUBLE_ID="5.97468982575" DECIMAL_ID="3.7315801827"
BOOLEAN_ID="false" TIME_ID="1994-05-08 04:39:54.000" DATE_ID="2069-03-06
05:18:23.000" TIMESTAMP_ID="2084-03-28 19:06:50.000" UNSIG_TIME_ID="2095-12-19
18:51:20.000" UNSIG_DATE_ID="1986-08-07 00:36:56.000"
UNSIG_TIMESTAMP_ID="2043-03-31 07:06:57.000" VARCHAR_ID="'Sample text'"
CHAR_ID="'a'" BINARY_ID="null" VARBINARY_ID="null" ID="1" UNSIG_ID="0"
BIG_ID="0" UNSIG_LONG_ID="0" TINY_ID="1" UNSIG_TINY_ID="1" SMALL_ID="1"
UNSIG_SMALL_ID="1" FLOAT_ID="1.5" UNSIG_FLOAT_ID="1.25" DOUBLE_ID="1.125"
UNSIG_DOUBLE_ID="4.304089208" DECIMAL_ID="8.42399458312" BOOLEAN_ID="false"
TIME_ID="2065-10-11 23:53:01.000" DATE_ID="2079-03-19 10:41:53.000"
TIMESTAMP_ID="1999-11-01 12:53:45.000" UNSIG_TIME_ID="2082-10-12 15:39:44.000"
UNSIG_DATE_ID="2056-11-26 14:25:03.000" UNSIG_TIMESTAMP_ID="1984-09-26
16:02:23.000" VARCHAR_ID="'Sample text'" CHAR_ID="'a'" BINARY_ID="null"
VARBINARY_ID="null"/>
2015-09-18
00:52:00,795|beaver.machine|INFO|16074|140258496624448|MainThread|<result
ID="0" UNSIG_ID="0" BIG_ID="0" UNSIG_LONG_ID="0" TINY_ID="0" UNSIG_TINY_ID="0"
SMALL_ID="0" UNSIG_SMALL_ID="0" FLOAT_ID="0.5" UNSIG_FLOAT_ID="0.25"
DOUBLE_ID="0.125" UNSIG_DOUBLE_ID="5.97468982575" DECIMAL_ID="3.7315801827"
BOOLEAN_ID="false" TIME_ID="1994-05-08 04:39:54.000" DATE_ID="2069-03-06
05:18:23.000" TIMESTAMP_ID="2084-03-28 19:06:50.000" UNSIG_TIME_ID="2095-12-19
18:51:20.000" UNSIG_DATE_ID="1986-08-07 00:36:56.000"
UNSIG_TIMESTAMP_ID="2043-03-31 07:06:57.000" VARCHAR_ID="'Sample text'"
CHAR_ID="'a'" BINARY_ID="null" VARBINARY_ID="null" ID="2" UNSIG_ID="0"
BIG_ID="0" UNSIG_LONG_ID="0" TINY_ID="2" UNSIG_TINY_ID="2" SMALL_ID="2"
UNSIG_SMALL_ID="2" FLOAT_ID="2.5" UNSIG_FLOAT_ID="2.25" DOUBLE_ID="2.125"
UNSIG_DOUBLE_ID="1.52891475818" DECIMAL_ID="2.31425713896" BOOLEAN_ID="true"
TIME_ID="2079-09-20 04:48:55.000" DATE_ID="2066-04-20 10:45:37.000"
TIMESTAMP_ID="2081-09-16 08:05:54.000" UNSIG_TIME_ID="2045-04-14 05:17:56.000"
UNSIG_DATE_ID="2052-04-25 18:55:49.000" UNSIG_TIMESTAMP_ID="2001-06-15
22:45:27.000" VARCHAR_ID="'Sample text'" CHAR_ID="'a'" BINARY_ID="null"
VARBINARY_ID="null"/>
2015-09-18
00:52:00,803|beaver.machine|INFO|16074|140258496624448|MainThread|<result
ID="0" UNSIG_ID="0" BIG_ID="0" UNSIG_LONG_ID="0" TINY_ID="0" UNSIG_TINY_ID="0"
SMALL_ID="0" UNSIG_SMALL_ID="0" FLOAT_ID="0.5" UNSIG_FLOAT_ID="0.25"
DOUBLE_ID="0.125" UNSIG_DOUBLE_ID="5.97468982575" DECIMAL_ID="3.7315801827"
BOOLEAN_ID="false" TIME_ID="1994-05-08 04:39:54.000" DATE_ID="2069-03-06
05:18:23.000" TIMESTAMP_ID="2084-03-28 19:06:50.000" UNSIG_TIME_ID="2095-12-19
18:51:20.000" UNSIG_DATE_ID="1986-08-07 00:36:56.000"
UNSIG_TIMESTAMP_ID="2043-03-31 07:06:57.000" VARCHAR_ID="'Sample text'"
CHAR_ID="'a'" BINARY_ID="null" VARBINARY_ID="null" ID="3" UNSIG_ID="0"
BIG_ID="0" UNSIG_LONG_ID="0" TINY_ID="3" UNSIG_TINY_ID="3" SMALL_ID="3"
UNSIG_SMALL_ID="3" FLOAT_ID="3.5" UNSIG_FLOAT_ID="3.25" DOUBLE_ID="3.125"
UNSIG_DOUBLE_ID="6.21974294126" DECIMAL_ID="9.18518005986" BOOLEAN_ID="false"
TIME_ID="2031-08-11 22:14:22.000" DATE_ID="2074-09-27 18:00:08.000"
TIMESTAMP_ID="1975-03-10 15:55:44.000" UNSIG_TIME_ID="2097-10-02 11:12:07.000"
UNSIG_DATE_ID="1978-07-15 22:27:52.000" UNSIG_TIMESTAMP_ID="2093-12-19
11:01:45.000" VARCHAR_ID="'Sample text'" CHAR_ID="'a'" BINARY_ID="null"
VARBINARY_ID="null"/>
Expected dat should include the table alias name, as below,
<result L.ID="0"
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
