You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Till (JIRA)" <ji...@apache.org> on 2016/08/02 22:03:20 UTC
[jira] [Commented] (ASTERIXDB-1562) NotImplemented Exception thrown
when external delimited file is loaded using sql++
[ https://issues.apache.org/jira/browse/ASTERIXDB-1562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15404896#comment-15404896 ]
Till commented on ASTERIXDB-1562:
---------------------------------
[~vignesh.raghunathan]: Could you add a) the stack trace of the exception for easier analysis and b) the load statement that you've used for easier reproduction?
> 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
>
> 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)