phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Lomore (JIRA)" <>
Subject [jira] [Created] (PHOENIX-3502) Support ARRAY DML in Calcite-Phoenix
Date Sun, 20 Nov 2016 23:26:58 GMT
Eric Lomore created PHOENIX-3502:

             Summary: Support ARRAY DML in Calcite-Phoenix
                 Key: PHOENIX-3502
             Project: Phoenix
          Issue Type: Improvement
            Reporter: Eric Lomore

Array construction DML's don't currently work as expected.

Initially it seemed like a type matching issue, but once I forced the correct types, the validator
still throws exceptions.

Example input query:
{code}String ddl = "CREATE TABLE " + tableName + " (region_name VARCHAR PRIMARY KEY,varchars
CHAR(5)[],integers INTEGER[],doubles DOUBLE[],bigints BIGINT[],chars CHAR(15)[],double1 DOUBLE,char1
CHAR(17),nullcheck INTEGER,chars2 CHAR(15)[])";

String dml = "UPSERT INTO " + tableName + "(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2)
VALUES('SF Bay Area'," +
                "ARRAY['2345','46345','23234']," +
                "ARRAY[2345,46345,23234,456]," +
                "ARRAY[23.45,46.345,23.234,45.6,5.78]," +
                "ARRAY[12,34,56,78,910]," +
                "ARRAY['a','bbbb','c','ddd','e']," +
                "23.45," +
                "'wert'," +
                "NULL," +
                "ARRAY['a','bbbb','c','ddd','e','foo']" +

Exception thrown:
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target
field 'VARCHARS' of type CHAR(5) ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
	at java.lang.reflect.Constructor.newInstance(
	at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(
	at org.apache.calcite.runtime.Resources$ExInst.ex(
	... 53 more

This message was sent by Atlassian JIRA

View raw message