br1ghtyang / asterixdb

Automatically exported from code.google.com/p/asterixdb
0 stars 0 forks source link

LOAD statement : Incomplete Exception message #520

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?

The issue here is that the number of fields in the Schema and the number of 
fields in the delimited text file are different, the delimited text file has 
two fields less as compared to the number of fields in the Schema.

Start asterix using managix one NC, CC and run these AQL statements from Web UI.

drop dataverse test if exists;
create dataverse test;
use dataverse test;

create type Schema as closed {
unique1:  int32,
unique2:  int32,
two:  int32,
four:  int32,
ten:  int32,
twenty:  int32,
onePercent: int32,
tenPercent:  int32,
twentyPercent:  int32,
fiftyPercent:  int32,
unique3:  int32,
evenOnePercent: int32,
oddOnePercent:  int32,
stringu1:  string,
stringu2:  string,
string4:  string
}

create dataset onektup(Schema) primary key unique2 ;

load dataset onektup using localfs
(("path"="localhost:///home/kfmohamm/data-gen/foo.adm"),("format"="delimited-tex
t"),("delimiter"="|")) pre-sorted;

I see only this Exception on the Web UI 
Encountered A [HyracksDataException]

Stack trace from cc.log

SEVERE: Job failed on account of:
exception during reading from external data source

edu.uci.ics.hyracks.api.exceptions.HyracksException: Job failed on account of:
exception during reading from external data source

        at edu.uci.ics.hyracks.control.cc.job.JobRun.waitForCompletion(JobRun.java:190)
        at edu.uci.ics.hyracks.control.cc.work.WaitForJobCompletionWork$1.run(WaitForJobCompletionWork.java:44)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:722)
Caused by: edu.uci.ics.hyracks.api.exceptions.HyracksDataException: exception 
during reading from external data source
        at edu.uci.ics.asterix.external.data.operator.ExternalDataScanOperatorDescriptor$1.initialize(ExternalDataScanOperatorDescriptor.java:68)
        at edu.uci.ics.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.initialize(SuperActivityOperatorNodePushable.java:81)
        at edu.uci.ics.hyracks.control.nc.Task.run(Task.java:228)
        ... 3 more
Caused by: edu.uci.ics.hyracks.api.exceptions.HyracksDataException: 
edu.uci.ics.hyracks.api.exceptions.HyracksDataException: Encountered A
        at edu.uci.ics.asterix.runtime.operators.file.AbstractTupleParser.parse(AbstractTupleParser.java:76)
        at edu.uci.ics.asterix.external.dataset.adapter.FileSystemBasedAdapter.start(FileSystemBasedAdapter.java:65)
        at edu.uci.ics.asterix.external.data.operator.ExternalDataScanOperatorDescriptor$1.initialize(ExternalDataScanOperatorDescriptor.java:66)
        ... 5 more
Caused by: edu.uci.ics.hyracks.api.exceptions.HyracksDataException: Encountered 
A
        at edu.uci.ics.hyracks.dataflow.common.data.parsers.IntegerParserFactory$1.parse(IntegerParserFactory.java:69)
        at edu.uci.ics.asterix.runtime.operators.file.DelimitedDataParser.parse(DelimitedDataParser.java:110)
        at edu.uci.ics.asterix.runtime.operators.file.AbstractTupleParser.parse(AbstractTupleParser.java:64)
        ... 7 more

Original issue reported on code.google.com by khfaraaz82 on 8 Jun 2013 at 2:58

Attachments:

GoogleCodeExporter commented 8 years ago
Given the recent changes in error propagation, this should now be fixed, will 
verify and update accordingly.

Original comment by RamanGro...@gmail.com on 16 Nov 2013 at 2:48