You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@asterixdb.apache.org by Yingyi Bu <bu...@gmail.com> on 2015/11/11 02:31:43 UTC

Fwd: loading csv file

Forward the question to Apache mailing list.

---------- Forwarded message ----------
From: Amer Ahmed <am...@umich.edu>
Date: Tue, Nov 10, 2015 at 5:21 PM
Subject: loading csv file
To: asterixdb-users <as...@googlegroups.com>


Hi,

I tried to load .csv file as both internal data-set and external data-set.
Both the times while loading it did not show any error but while fetching
the records it is throwing an exception.
Can I get a working example as to how to load a .csv file.

Regards,
Amer

-- 
You received this message because you are subscribed to the Google Groups
"asterixdb-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to asterixdb-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: loading csv file

Posted by Yingyi Bu <bu...@gmail.com>.
Here you go:

load from local file system:
https://github.com/apache/incubator-asterixdb/blob/master/asterix-app/src/test/resources/runtimets/queries/load/csv_01/csv_01.2.update.aql

load from HDFS:
https://github.com/apache/incubator-asterixdb/blob/master/asterix-app/src/test/resources/runtimets/queries/dml/load-from-hdfs/load-from-hdfs.2.update.aql

create external dataset using HDFS:
https://github.com/apache/incubator-asterixdb/blob/master/asterix-app/src/test/resources/runtimets/queries/hdfs/hdfs_02/hdfs_02.1.ddl.aql

Best,
Yingyi


On Tue, Nov 10, 2015 at 5:31 PM, Yingyi Bu <bu...@gmail.com> wrote:

> Forward the question to Apache mailing list.
>
> ---------- Forwarded message ----------
> From: Amer Ahmed <am...@umich.edu>
> Date: Tue, Nov 10, 2015 at 5:21 PM
> Subject: loading csv file
> To: asterixdb-users <as...@googlegroups.com>
>
>
> Hi,
>
> I tried to load .csv file as both internal data-set and external data-set.
> Both the times while loading it did not show any error but while fetching
> the records it is throwing an exception.
> Can I get a working example as to how to load a .csv file.
>
> Regards,
> Amer
>
> --
> You received this message because you are subscribed to the Google Groups
> "asterixdb-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to asterixdb-users+unsubscribe@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
>