[
https://issues.apache.org/jira/browse/ASTERIXDB-1562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15419860#comment-15419860
]
Vignesh Raghunathan commented on ASTERIXDB-1562:
------------------------------------------------
As discussed in the weekly meeting, If Date type isn't supported for loading
data from local filesystem to a dataset, I can close this ticket.
It would be helpful if the unsupported types are mentioned in the
documentation.
> 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)
