Markus Steindl created PHOENIX-5083:
---------------------------------------
Summary: Array type in Hive Phoenix tables does not work
Key: PHOENIX-5083
URL: https://issues.apache.org/jira/browse/PHOENIX-5083
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.7.0
Reporter: Markus Steindl
In the following example I create a Hive Phoenix table with array<int> column.
However, if I put something into this column, NULL is stored instead.
I'm using hdp 2.6.0.3-8 and phoenix 4.7.0.2.6.0.3-8.
{{create table phoenix_table (}}
{{ id int,}}
{{ arr array<int>}}
{{)}}
{{STORED BY 'org.apache.phoenix.hive.PhoenixStorageHandler'}}
{{TBLPROPERTIES (}}
{{"phoenix.table.name" = "phoenix_table",}}
{{"phoenix.zookeeper.quorum" = "url1,url2,url3",}}
{{"phoenix.zookeeper.znode.parent" = "/hbase-unsecure",}}
{{"phoenix.zookeeper.client.port" = "2181",}}
{{"phoenix.rowkeys" = "id",}}
{{"phoenix.column.mapping" = "id:id, arr:arr",}}
{{"phoenix.table.options" = "DATA_BLOCK_ENCODING='DIFF'"}}
{{);}}
{{insert into phoenix_table}}
{{select * from (}}
{{select 123 as id, array(4, 5, 6) as arr}}
{{) t;}}
{{select * from phoenix_table;}}
{{123 NULL}}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
