You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Alicia Ying Shu (JIRA)" <ji...@apache.org> on 2015/10/23 20:03:27 UTC

[jira] [Updated] (PHOENIX-2351) Phoenix query table alias name is not coming the output xml file

     [ https://issues.apache.org/jira/browse/PHOENIX-2351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alicia Ying Shu updated PHOENIX-2351:
-------------------------------------
    Description: 
Phoenix query table alias name is not coming the output xml file.

>From sqlline:
!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;
When alias name is used in the query (in this example, table alias name is “L”) then the expected xml output need to have the alias name,
Current output:
<resultset>
<result ID="0" UNSIG_ID="0" BIG_ID="0" UNSIG_LONG_ID="0" ...
......
Expected output:
<resultset>
<result L.ID="0" UNSIG_ID="0" BIG_ID="0" UNSIG_LONG_ID="0" ...

  was:
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|Setting property: [isolation, TRANSACTION_READ_COMMITTED]
2015-09-18 00:51:10,772|beaver.machine|INFO|16074|140258496624448|MainThread|Setting property: [run, /grid/0/hadoopqe/artifacts/phoenixSQLQuery/inputFile.txt]
2015-09-18 00:51:10,772|beaver.machine|INFO|16074|140258496624448|MainThread|issuing: !connect jdbc:phoenix:os-u14-qubazs-phoenix-2.novalocal:2181:/hbase-secure none none org.apache.phoenix.jdbc.PhoenixDriver
2015-09-18 00:51:10,775|beaver.machine|INFO|16074|140258496624448|MainThread|Connecting to jdbc:phoenix:os-u14-qubazs-phoenix-2.novalocal:2181:/hbase-secure
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"


> 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.
> From sqlline:
> !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;
> When alias name is used in the query (in this example, table alias name is “L”) then the expected xml output need to have the alias name,
> Current output:
> <resultset>
> <result ID="0" UNSIG_ID="0" BIG_ID="0" UNSIG_LONG_ID="0" ...
> ......
> Expected output:
> <resultset>
> <result L.ID="0" UNSIG_ID="0" BIG_ID="0" UNSIG_LONG_ID="0" ...



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)