asterixdb-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ian Maxon <ima...@uci.edu>
Subject Re: Error loading data
Date Wed, 30 Mar 2016 18:11:08 GMT
It should just be a quoted string with commas inside separating the URL-ish
paths, so like:

load dataset foo using localfs
"path"="localhost:///data/path/to/file/file.adm,localhost:///data/path/to/file/file2.adm,localhost:///data/path/to/file/file3.adm"),("format"="adm"));

On Wed, Mar 30, 2016 at 6:24 AM, Magnus Kongshem <kongshem@stud.ntnu.no>
wrote:

> Yes I am.
>
> So, combinding each file will and doing the command once will solve it, or
> do I have to input the AQL for each file like below?
>
> use dataverse bigd;
> load dataset posdata using localfs
>     (("path"="localhost:///data/path/to/file/file.adm"),("format"="adm"));
> (("path"="localhost:///data/path/to/file/file2.adm"),("format"="adm"));
> (("path"="localhost:///data/path/to/file/file3.adm"),("format"="adm"));
>
>
> BG
> Magnus
>
>
> On Wed, Mar 30, 2016 at 3:21 PM, Wail Alkowaileet <wael.y.k@gmail.com>
> wrote:
>
>> Are you trying to load each file separately?
>> That AFAK is not supported.
>> On Mar 30, 2016 16:13, "Magnus Kongshem" <kongshem@stud.ntnu.no> wrote:
>>
>>> I will be loading 12 files.
>>>
>>> AQL below:
>>>
>>> use dataverse bigd;
>>> load dataset posdata using localfs
>>>
>>> (("path"="localhost:///data/path/to/file/file.adm"),("format"="adm"));
>>>
>>> Will it be solved if I concatinate the files and do the dataset loading
>>> only once?
>>>
>>> Magnus
>>>
>>> On Wed, Mar 30, 2016 at 3:06 PM, Wail Alkowaileet <wael.y.k@gmail.com>
>>> wrote:
>>>
>>>> How many files you're loading?
>>>> Can you send the loading AQL?
>>>> On Mar 30, 2016 16:01, "Magnus Kongshem" <kongshem@stud.ntnu.no> wrote:
>>>>
>>>>> Using asterixdb v0.8.8.
>>>>>
>>>>> I am loading data into my asterixDB instance.
>>>>>
>>>>> Loading the first file is successful. But when I try to load another
>>>>> file, I get a "Internal error. Please check instance logs for further
>>>>> details. [NullPointerException]"
>>>>>
>>>>> The files are of the type adm and as good as equal in size (3 gb).
>>>>>
>>>>> My instance was initialized with these commands:
>>>>>
>>>>> drop dataverse bigd if exists;
>>>>>     create dataverse bigd;
>>>>>     use dataverse bigd;
>>>>>
>>>>>     create type table as open {
>>>>> uid: uuid,
>>>>>         campus: string,
>>>>> building: string,
>>>>> floor: string,
>>>>>         timestamp: int32,
>>>>> dayOfWeek: int32,
>>>>> hourOfDay: int32,
>>>>>         latitude: double,
>>>>>         salt_timestamp: int32,
>>>>>         longitude: double,
>>>>>         id: string,
>>>>> accuracy: double
>>>>>     }
>>>>> create dataset posdata(table)
>>>>>     primary key uid autogenerated;
>>>>> create index stamp on posdata(timestamp);
>>>>> create index hour on posdata(hourOfDay);
>>>>> create index day on posdata(dayOfWeek);
>>>>>
>>>>> My log file is attached.
>>>>>
>>>>> Any help?
>>>>>
>>>>> --
>>>>>
>>>>> Mvh
>>>>>
>>>>> Magnus Kongshem
>>>>>
>>>>> NTNU
>>>>> +47 415 65 906
>>>>>
>>>>
>>>
>>>
>>> --
>>>
>>> Mvh
>>>
>>> Magnus Alderslyst Kongshem
>>> Leder av seniorkomiteen
>>> Online, linjeforeningen for informatikk
>>> +47 415 65 906
>>>
>>
>
>
> --
>
> Mvh
>
> Magnus Alderslyst Kongshem
> Leder av seniorkomiteen
> Online, linjeforeningen for informatikk
> +47 415 65 906
>

Mime
View raw message