asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vignesh Raghunathan (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (ASTERIXDB-1562) NotImplemented Exception thrown when external delimited file is loaded using sql++
Date Tue, 02 Aug 2016 22:51:20 GMT

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

Vignesh Raghunathan 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

{code}
load  table call_center using localfs ((`path`=`hostname://<path to call_center.dat>`),(`format`=`delimited-text`),(`delimiter`=`|`));
{code}

The following exceptions are thrown:

{code}
org.apache.hyracks.api.exceptions.HyracksException: Job failed on account of:
HYR0002: org.apache.hyracks.api.exceptions.HyracksDataException: No value parser factory for
fields of type DATE

	at org.apache.hyracks.control.cc.job.JobRun.waitForCompletion(JobRun.java:212)
	at org.apache.hyracks.control.cc.work.WaitForJobCompletionWork$1.run(WaitForJobCompletionWork.java:48)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: HYR0002: org.apache.hyracks.api.exceptions.HyracksDataException:
No value parser factory for fields of type DATE
	at org.apache.hyracks.control.common.utils.ExceptionUtils.setNodeIds(ExceptionUtils.java:62)
	at org.apache.hyracks.control.nc.Task.run(Task.java:319)
	... 3 more
Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: org.apache.hyracks.api.exceptions.HyracksDataException:
No value parser factory for fields of type DATE
	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.runInParallel(SuperActivityOperatorNodePushable.java:218)
	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.initialize(SuperActivityOperatorNodePushable.java:83)
	at org.apache.hyracks.control.nc.Task.run(Task.java:263)
	... 3 more
Caused by: java.util.concurrent.ExecutionException: org.apache.hyracks.api.exceptions.HyracksDataException:
No value parser factory for fields of type DATE
	at java.util.concurrent.FutureTask.report(FutureTask.java:122)
	at java.util.concurrent.FutureTask.get(FutureTask.java:192)
	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.runInParallel(SuperActivityOperatorNodePushable.java:212)
	... 5 more
Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: No value parser factory
for fields of type DATE
	at org.apache.asterix.external.operators.ExternalDataScanOperatorDescriptor$1.initialize(ExternalDataScanOperatorDescriptor.java:65)
	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.lambda$initialize$0(SuperActivityOperatorNodePushable.java:83)
	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable$$Lambda$7/1125281803.runAction(Unknown
Source)
	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable$1.call(SuperActivityOperatorNodePushable.java:205)
	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable$1.call(SuperActivityOperatorNodePushable.java:202)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	... 3 more
Caused by: org.apache.hyracks.algebricks.common.exceptions.NotImplementedException: No value
parser factory for fields of type DATE
	at org.apache.asterix.external.util.ExternalDataUtils.getParserFactory(ExternalDataUtils.java:196)
	at org.apache.asterix.external.util.ExternalDataUtils.getValueParserFactories(ExternalDataUtils.java:188)
	at org.apache.asterix.external.parser.factory.DelimitedDataParserFactory.createParser(DelimitedDataParserFactory.java:44)
	at org.apache.asterix.external.parser.factory.DelimitedDataParserFactory.createRecordParser(DelimitedDataParserFactory.java:40)
	at org.apache.asterix.external.provider.DataflowControllerProvider.getDataflowController(DataflowControllerProvider.java:69)
	at org.apache.asterix.external.adapter.factory.GenericAdapterFactory.createAdapter(GenericAdapterFactory.java:101)
	at org.apache.asterix.external.operators.ExternalDataScanOperatorDescriptor$1.initialize(ExternalDataScanOperatorDescriptor.java:61)
	... 8 more
Aug 03, 2016 4:19:23 AM org.apache.asterix.api.http.servlet.APIServlet doPost
SEVERE: Job failed on account of:
HYR0002: org.apache.hyracks.api.exceptions.HyracksDataException: No value parser factory for
fields of type DATE

org.apache.hyracks.api.exceptions.HyracksException: Job failed on account of:
HYR0002: org.apache.hyracks.api.exceptions.HyracksDataException: No value parser factory for
fields of type DATE

	at org.apache.hyracks.control.cc.job.JobRun.waitForCompletion(JobRun.java:212)
	at org.apache.hyracks.control.cc.work.WaitForJobCompletionWork$1.run(WaitForJobCompletionWork.java:48)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: HYR0002: org.apache.hyracks.api.exceptions.HyracksDataException:
No value parser factory for fields of type DATE
	at org.apache.hyracks.control.common.utils.ExceptionUtils.setNodeIds(ExceptionUtils.java:62)
	at org.apache.hyracks.control.nc.Task.run(Task.java:319)
	... 3 more
Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: org.apache.hyracks.api.exceptions.HyracksDataException:
No value parser factory for fields of type DATE
	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.runInParallel(SuperActivityOperatorNodePushable.java:218)
	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.initialize(SuperActivityOperatorNodePushable.java:83)
	at org.apache.hyracks.control.nc.Task.run(Task.java:263)
	... 3 more
Caused by: java.util.concurrent.ExecutionException: org.apache.hyracks.api.exceptions.HyracksDataException:
No value parser factory for fields of type DATE
	at java.util.concurrent.FutureTask.report(FutureTask.java:122)
	at java.util.concurrent.FutureTask.get(FutureTask.java:192)
	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.runInParallel(SuperActivityOperatorNodePushable.java:212)
	... 5 more
Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: No value parser factory
for fields of type DATE
	at org.apache.asterix.external.operators.ExternalDataScanOperatorDescriptor$1.initialize(ExternalDataScanOperatorDescriptor.java:65)
	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.lambda$initialize$0(SuperActivityOperatorNodePushable.java:83)
	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable$$Lambda$7/1125281803.runAction(Unknown
Source)
	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable$1.call(SuperActivityOperatorNodePushable.java:205)
	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable$1.call(SuperActivityOperatorNodePushable.java:202)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	... 3 more
Caused by: org.apache.hyracks.algebricks.common.exceptions.NotImplementedException: No value
parser factory for fields of type DATE
	at org.apache.asterix.external.util.ExternalDataUtils.getParserFactory(ExternalDataUtils.java:196)
	at org.apache.asterix.external.util.ExternalDataUtils.getValueParserFactories(ExternalDataUtils.java:188)
	at org.apache.asterix.external.parser.factory.DelimitedDataParserFactory.createParser(DelimitedDataParserFactory.java:44)
	at org.apache.asterix.external.parser.factory.DelimitedDataParserFactory.createRecordParser(DelimitedDataParserFactory.java:40)
	at org.apache.asterix.external.provider.DataflowControllerProvider.getDataflowController(DataflowControllerProvider.java:69)
	at org.apache.asterix.external.adapter.factory.GenericAdapterFactory.createAdapter(GenericAdapterFactory.java:101)
	at org.apache.asterix.external.operators.ExternalDataScanOperatorDescriptor$1.initialize(ExternalDataScanOperatorDescriptor.java:61)
	... 8 more
{code}


  was:
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

{code}
load  table call_center using localfs ((`path`=`hostname://<path to call_center.dat>`),(`format`=`delimited-text`),(`delimiter`=`|`));
{code}

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
>         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
> {code}
> load  table call_center using localfs ((`path`=`hostname://<path to call_center.dat>`),(`format`=`delimited-text`),(`delimiter`=`|`));
> {code}
> The following exceptions are thrown:
> {code}
> org.apache.hyracks.api.exceptions.HyracksException: Job failed on account of:
> HYR0002: org.apache.hyracks.api.exceptions.HyracksDataException: No value parser factory
for fields of type DATE
> 	at org.apache.hyracks.control.cc.job.JobRun.waitForCompletion(JobRun.java:212)
> 	at org.apache.hyracks.control.cc.work.WaitForJobCompletionWork$1.run(WaitForJobCompletionWork.java:48)
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> 	at java.lang.Thread.run(Thread.java:745)
> Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: HYR0002: org.apache.hyracks.api.exceptions.HyracksDataException:
No value parser factory for fields of type DATE
> 	at org.apache.hyracks.control.common.utils.ExceptionUtils.setNodeIds(ExceptionUtils.java:62)
> 	at org.apache.hyracks.control.nc.Task.run(Task.java:319)
> 	... 3 more
> Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: org.apache.hyracks.api.exceptions.HyracksDataException:
No value parser factory for fields of type DATE
> 	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.runInParallel(SuperActivityOperatorNodePushable.java:218)
> 	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.initialize(SuperActivityOperatorNodePushable.java:83)
> 	at org.apache.hyracks.control.nc.Task.run(Task.java:263)
> 	... 3 more
> Caused by: java.util.concurrent.ExecutionException: org.apache.hyracks.api.exceptions.HyracksDataException:
No value parser factory for fields of type DATE
> 	at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> 	at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> 	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.runInParallel(SuperActivityOperatorNodePushable.java:212)
> 	... 5 more
> Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: No value parser factory
for fields of type DATE
> 	at org.apache.asterix.external.operators.ExternalDataScanOperatorDescriptor$1.initialize(ExternalDataScanOperatorDescriptor.java:65)
> 	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.lambda$initialize$0(SuperActivityOperatorNodePushable.java:83)
> 	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable$$Lambda$7/1125281803.runAction(Unknown
Source)
> 	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable$1.call(SuperActivityOperatorNodePushable.java:205)
> 	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable$1.call(SuperActivityOperatorNodePushable.java:202)
> 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> 	... 3 more
> Caused by: org.apache.hyracks.algebricks.common.exceptions.NotImplementedException: No
value parser factory for fields of type DATE
> 	at org.apache.asterix.external.util.ExternalDataUtils.getParserFactory(ExternalDataUtils.java:196)
> 	at org.apache.asterix.external.util.ExternalDataUtils.getValueParserFactories(ExternalDataUtils.java:188)
> 	at org.apache.asterix.external.parser.factory.DelimitedDataParserFactory.createParser(DelimitedDataParserFactory.java:44)
> 	at org.apache.asterix.external.parser.factory.DelimitedDataParserFactory.createRecordParser(DelimitedDataParserFactory.java:40)
> 	at org.apache.asterix.external.provider.DataflowControllerProvider.getDataflowController(DataflowControllerProvider.java:69)
> 	at org.apache.asterix.external.adapter.factory.GenericAdapterFactory.createAdapter(GenericAdapterFactory.java:101)
> 	at org.apache.asterix.external.operators.ExternalDataScanOperatorDescriptor$1.initialize(ExternalDataScanOperatorDescriptor.java:61)
> 	... 8 more
> Aug 03, 2016 4:19:23 AM org.apache.asterix.api.http.servlet.APIServlet doPost
> SEVERE: Job failed on account of:
> HYR0002: org.apache.hyracks.api.exceptions.HyracksDataException: No value parser factory
for fields of type DATE
> org.apache.hyracks.api.exceptions.HyracksException: Job failed on account of:
> HYR0002: org.apache.hyracks.api.exceptions.HyracksDataException: No value parser factory
for fields of type DATE
> 	at org.apache.hyracks.control.cc.job.JobRun.waitForCompletion(JobRun.java:212)
> 	at org.apache.hyracks.control.cc.work.WaitForJobCompletionWork$1.run(WaitForJobCompletionWork.java:48)
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> 	at java.lang.Thread.run(Thread.java:745)
> Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: HYR0002: org.apache.hyracks.api.exceptions.HyracksDataException:
No value parser factory for fields of type DATE
> 	at org.apache.hyracks.control.common.utils.ExceptionUtils.setNodeIds(ExceptionUtils.java:62)
> 	at org.apache.hyracks.control.nc.Task.run(Task.java:319)
> 	... 3 more
> Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: org.apache.hyracks.api.exceptions.HyracksDataException:
No value parser factory for fields of type DATE
> 	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.runInParallel(SuperActivityOperatorNodePushable.java:218)
> 	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.initialize(SuperActivityOperatorNodePushable.java:83)
> 	at org.apache.hyracks.control.nc.Task.run(Task.java:263)
> 	... 3 more
> Caused by: java.util.concurrent.ExecutionException: org.apache.hyracks.api.exceptions.HyracksDataException:
No value parser factory for fields of type DATE
> 	at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> 	at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> 	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.runInParallel(SuperActivityOperatorNodePushable.java:212)
> 	... 5 more
> Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: No value parser factory
for fields of type DATE
> 	at org.apache.asterix.external.operators.ExternalDataScanOperatorDescriptor$1.initialize(ExternalDataScanOperatorDescriptor.java:65)
> 	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.lambda$initialize$0(SuperActivityOperatorNodePushable.java:83)
> 	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable$$Lambda$7/1125281803.runAction(Unknown
Source)
> 	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable$1.call(SuperActivityOperatorNodePushable.java:205)
> 	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable$1.call(SuperActivityOperatorNodePushable.java:202)
> 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> 	... 3 more
> Caused by: org.apache.hyracks.algebricks.common.exceptions.NotImplementedException: No
value parser factory for fields of type DATE
> 	at org.apache.asterix.external.util.ExternalDataUtils.getParserFactory(ExternalDataUtils.java:196)
> 	at org.apache.asterix.external.util.ExternalDataUtils.getValueParserFactories(ExternalDataUtils.java:188)
> 	at org.apache.asterix.external.parser.factory.DelimitedDataParserFactory.createParser(DelimitedDataParserFactory.java:44)
> 	at org.apache.asterix.external.parser.factory.DelimitedDataParserFactory.createRecordParser(DelimitedDataParserFactory.java:40)
> 	at org.apache.asterix.external.provider.DataflowControllerProvider.getDataflowController(DataflowControllerProvider.java:69)
> 	at org.apache.asterix.external.adapter.factory.GenericAdapterFactory.createAdapter(GenericAdapterFactory.java:101)
> 	at org.apache.asterix.external.operators.ExternalDataScanOperatorDescriptor$1.initialize(ExternalDataScanOperatorDescriptor.java:61)
> 	... 8 more
> {code}



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

Mime
View raw message