[jira] [Created] (TAJO-1353) CREATE TABLE should support the nested record definition.

[Hyunsik Choi (JIRA)]

Hyunsik Choi created TAJO-1353:
----------------------------------

             Summary: CREATE TABLE should support the nested record definition.
                 Key: TAJO-1353
                 URL: https://issues.apache.org/jira/browse/TAJO-1353
             Project: Tajo
          Issue Type: Sub-task
          Components: parser
            Reporter: Hyunsik Choi
            Assignee: Hyunsik Choi
             Fix For: 0.11


This patch adds the nested record definition to CREATE TABLE BNF. The changed 
BNF is as follows:

{code}
predefined_type
  : character_string_type
  | national_character_string_type
  | binary_large_object_string_type
  | numeric_type
  | boolean_type
  | datetime_type
  | bit_type
  | binary_type
  | network_type
  | struct_type
  ;

struct_type
  : STRUCT table_elements
  ;

table_elements
  : LEFT_PAREN field_element (COMMA field_element)* RIGHT_PAREN
  ;
{code}

Example statements as follows:
{code:sql}
CREATE TABLE T1 (
  A TEXT, 
  B INT4, 
  C STRUCT (
    D TEXT, 
    E INT8, 
    F STRUCT (
      G INT1, H FLOAT4
    )
  ), 
  Z FLOAT8
);
{code}



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