[
https://issues.apache.org/jira/browse/BEAM-4196?focusedWorklogId=99797&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-99797
]
ASF GitHub Bot logged work on BEAM-4196:
----------------------------------------
Author: ASF GitHub Bot
Created on: 08/May/18 23:41
Start Date: 08/May/18 23:41
Worklog Time Spent: 10m
Work Description: akedin commented on issue #5276: [BEAM-4196][SQL]
Support complex types in DDL
URL: https://github.com/apache/beam/pull/5276#issuecomment-387575768
Updated:
* removed postfix array support;
* added
(`BeamDdlNestedTypesTest`)[https://github.com/apache/beam/pull/5276/files#diff-794c03679a02b7349f5070def998ce7a]
which tests things with QuickCheck. Examples:
```
create table tablename ( fieldName MAP<DOUBLE,
ARRAY<ARRAY<ARRAY<MAP<BOOLEAN, MAP<DECIMAL, TINYINT>>>>>> ) TYPE 'text'
LOCATION '/home/admin/person'
create table tablename ( fieldName MAP<BOOLEAN, MAP<FLOAT, ARRAY<BOOLEAN>>>
) TYPE 'text' LOCATION '/home/admin/person'
create table tablename ( fieldName ARRAY<ARRAY<FLOAT>> ) TYPE 'text'
LOCATION '/home/admin/person'
create table tablename ( fieldName MAP<INTEGER, MAP<INTEGER, MAP<INTEGER,
MAP<SMALLINT, ROW<field_0 INTEGER,field_1 TIMESTAMP,field_2 TIMESTAMP,field_3
TIMESTAMP>>>>> ) TYPE 'text' LOCATION '/home/admin/person'
create table tablename ( fieldName MAP<BOOLEAN, ROW<field_0 INTEGER,field_1
DECIMAL,field_2 VARCHAR>> ) TYPE 'text' LOCATION '/home/admin/person'
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 99797)
Time Spent: 3.5h (was: 3h 20m)
> [SQL] Support Complex Types in DDL
> ----------------------------------
>
> Key: BEAM-4196
> URL: https://issues.apache.org/jira/browse/BEAM-4196
> Project: Beam
> Issue Type: New Feature
> Components: dsl-sql
> Reporter: Anton Kedin
> Assignee: Anton Kedin
> Priority: Major
> Time Spent: 3.5h
> Remaining Estimate: 0h
>
> Neither our DDL parser we copied from calcite-server or the calcite-server
> don't support complex types in DDL. If we want to model something like JSON
> objects we need to support at least Arrays and nested Rows.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
