Return-Path: X-Original-To: apmail-asterixdb-users-archive@minotaur.apache.org Delivered-To: apmail-asterixdb-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0FDE419FF6 for ; Wed, 30 Mar 2016 13:21:08 +0000 (UTC) Received: (qmail 60957 invoked by uid 500); 30 Mar 2016 13:21:08 -0000 Delivered-To: apmail-asterixdb-users-archive@asterixdb.apache.org Received: (qmail 60932 invoked by uid 500); 30 Mar 2016 13:21:07 -0000 Mailing-List: contact users-help@asterixdb.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@asterixdb.incubator.apache.org Delivered-To: mailing list users@asterixdb.incubator.apache.org Received: (qmail 60917 invoked by uid 99); 30 Mar 2016 13:21:07 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 30 Mar 2016 13:21:07 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 39E351A1309 for ; Wed, 30 Mar 2016 13:21:07 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.179 X-Spam-Level: * X-Spam-Status: No, score=1.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id KpILlIHdPpM0 for ; Wed, 30 Mar 2016 13:21:05 +0000 (UTC) Received: from mail-lf0-f54.google.com (mail-lf0-f54.google.com [209.85.215.54]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 981005F1D5 for ; Wed, 30 Mar 2016 13:21:04 +0000 (UTC) Received: by mail-lf0-f54.google.com with SMTP id k79so36053434lfb.2 for ; Wed, 30 Mar 2016 06:21:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to; bh=AmyKu4CN/eAW9o7kT1cv0UGCWlU6xl1ukwMHXPdW4Xc=; b=IUH73r+x6FYvhONlx/bKsZ7kJaNkQbK4VrFRjCvLi5XnxnsCmVR7yweR7JjaWPWr3s Q9SCtmS+KC+QeG3+mJBlR0JtFN+qAE3R5IkRLm4WvXSR5XpES0HMcC2ZP5BRf5xdzld0 D1h7RJqym/KNLBHH/e+TplR4dok41yw+oEM0W4C4sBzyDvhg2qxKbIVsOWwOt7OChdOr yqWB0L4zOXSmfHtRx4UCmmICv7HH2xCYE00dXze1K7rQWnZBojzFstibSQ06HwUU5hpP tK0lYlNbIP9NvU6XE8i4yguY3uNuNX2+4Q/Rv7izg6lr8MxQG0vEskp8VzJdQ2y+ICtP uvQw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to; bh=AmyKu4CN/eAW9o7kT1cv0UGCWlU6xl1ukwMHXPdW4Xc=; b=MNOhvihq+mJ4m9sUSNcaxd8Sv4/TSWyX0N83rgsCE1OB9br8tVfpMigE0hoLF9B9lj a60MmoIlhmx9uZ4o7VxKzNpsAgWfmyIsfeD/nXq3T3YXiHH0BUxH55Cdb2+6geH9MuVs Z9/Gau6zyhcaSf19IELgYuub46VzBRFypuhPU9jR2KdD7mgdgEOYoByqRQTmlFkIRxai Qx3iz2lMwWfnoRs7dfoAkFwXJtUYcJ3SlW9oDnuqwq1rNIh+xxYbyNwrIVgTOLNtja6E wF4cnZ0HuKsYsX5t8USGrDVkK2eUqiDz/rnFOM5ZM6fMlcBnkLhmSG2pCZ1XwbNDtxM5 zYEg== X-Gm-Message-State: AD7BkJL9QwYOMyAl4or2+Q4gvdivA6DAo1sfnEO45zKTaVevpXfaFtL/JsPYm/qMoHBdLNvYoSIifF6023jm7Q== MIME-Version: 1.0 X-Received: by 10.25.86.144 with SMTP id k138mr4081625lfb.59.1459344064066; Wed, 30 Mar 2016 06:21:04 -0700 (PDT) Received: by 10.114.200.41 with HTTP; Wed, 30 Mar 2016 06:21:04 -0700 (PDT) Received: by 10.114.200.41 with HTTP; Wed, 30 Mar 2016 06:21:04 -0700 (PDT) In-Reply-To: References: Date: Wed, 30 Mar 2016 16:21:04 +0300 Message-ID: Subject: Re: Error loading data From: Wail Alkowaileet To: users@asterixdb.incubator.apache.org Content-Type: multipart/alternative; boundary=001a1140820e8b6435052f44044a --001a1140820e8b6435052f44044a Content-Type: text/plain; charset=UTF-8 Are you trying to load each file separately? That AFAK is not supported. On Mar 30, 2016 16:13, "Magnus Kongshem" 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 > wrote: > >> How many files you're loading? >> Can you send the loading AQL? >> On Mar 30, 2016 16:01, "Magnus Kongshem" 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 > --001a1140820e8b6435052f44044a Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Are you trying to load each file separately?
That AFAK is not supported.

On Mar 30, 2016 16:13, "Magnus Kongshem&quo= t; <kongshem@stud.ntnu.no&g= t; wrote:
I will be loading 12 files.

AQL below:

use dataverse bigd;
load dataset posdata us= ing localfs
=C2=A0 =C2=A0 (("path"=3D"localhost://= /data/path/to/file/file.adm"),("format"=3D"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&quo= t; <kongshem@= stud.ntnu.no> wrote:
Using asterixdb v0.8.8.

I am loading data int= o 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. [Nul= lPointerException]"

The files are of t= he type adm and as good as equal in size (3 gb).

M= y instance was initialized with these commands:

drop dataverse bigd if exists;
=C2=A0 =C2=A0 create dataverse = bigd;
=C2=A0 =C2=A0 use dataverse bigd;

= =C2=A0 =C2=A0 create type table as open {
uid: uuid,
=C2=A0 =C2=A0 =C2=A0 =C2=A0 camp= us: string,
building= : string,
floor: str= ing,
=C2=A0 =C2=A0 =C2=A0 =C2=A0 timestamp: int32,
dayOfWeek: int32,
hourOfDay: int32,
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 latitude: double,
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 salt_timestamp: int32,
=C2=A0 =C2=A0 =C2=A0 =C2=A0 longitude:= double,
=C2=A0 =C2=A0 =C2=A0 =C2=A0 id: string,
accuracy: double
=C2=A0 = =C2=A0 }
create dataset posdata(table)
=C2=A0 =C2=A0 pr= imary key uid autogenerated;
create index stamp on posdata(timest= amp);
create index hour on posdata(hourOfDay);
create i= ndex 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, linjef= oreningen for informatikk
+47 415 65 906

--001a1140820e8b6435052f44044a--