asterixdb-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Magnus Kongshem <kongs...@stud.ntnu.no>
Subject Re: Error loading data
Date Wed, 30 Mar 2016 13:24:21 GMT
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