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

Vignesh Raghunathan updated ASTERIXDB-1562:
-------------------------------------------
    Attachment: call_center.dat

Delimited data file

> NotImplemented Exception thrown when external delimited file is loaded using 
> sql++
> ----------------------------------------------------------------------------------
>
>                 Key: ASTERIXDB-1562
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1562
>             Project: Apache AsterixDB
>          Issue Type: Bug
>         Environment: Build 380b0a27
>            Reporter: Vignesh Raghunathan
>         Attachments: call_center.dat
>
>
> To reproduce the issue, create a type and table using sql++ as follows:
> {code}
> create type call_center_type as closed {
>     cc_call_center_sk:         int64                                  ,
>     cc_call_center_id:         string                                 ,
>     cc_rec_start_date:         date?                        ,
>     cc_rec_end_date:           date?                        ,
>     cc_closed_date_sk:         int64?                       ,
>     cc_open_date_sk:           int64?                       ,
>     cc_name:                   string?                        ,
>     cc_class:                  string?                        ,
>     cc_employees:              int64?                       ,
>     cc_sq_ft:                  int64?                       ,
>     cc_hours:                  string?                      ,
>     cc_manager:                string?                        ,
>     cc_mkt_id:                 int64?                       ,
>     cc_mkt_class:              string?                      ,
>     cc_mkt_desc:               string?                        ,
>     cc_market_manager:         string?                        ,
>     cc_division:               int64?                       ,
>     cc_division_name:          string?                        ,
>     cc_company:                int64?                       ,
>     cc_company_name:           string?                      ,
>     cc_street_number:          int64?                         ,
>     cc_street_name:            string?                        ,
>     cc_street_type:            string?                      ,
>     cc_suite_number:           string?                      ,
>     cc_city:                   string?                        ,
>     cc_county:                 string?                        ,
>     cc_state:                  string?                      ,
>     cc_zip:                    string?                      ,
>     cc_country:                string?                        ,
>     cc_gmt_offset:             double?                        ,
>     cc_tax_percentage:         double?                        
> }
> create table call_center (call_center_type)
> primary key cc_call_center_sk;
> {code}
> Then load the file call_center.dat
> The following exception is thrown:
> No value parser factory for fields of type DATE [NotImplementedException]



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

Reply via email to