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:01:20 UTC
[jira] [Updated] (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:all-tabpanel ]
Till updated ASTERIXDB-1562:
----------------------------
Description:
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]
was:
To reproduce the issue, create a type and table using sql++ as follows:
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;
Then load the file call_center.dat
The following exception is thrown:
No value parser factory for fields of type DATE [NotImplementedException]
> 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)