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 99D7F18BF8 for ; Sun, 20 Sep 2015 22:36:55 +0000 (UTC) Received: (qmail 8230 invoked by uid 500); 20 Sep 2015 22:36:55 -0000 Delivered-To: apmail-asterixdb-users-archive@asterixdb.apache.org Received: (qmail 8202 invoked by uid 500); 20 Sep 2015 22:36:55 -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 8189 invoked by uid 99); 20 Sep 2015 22:36:55 -0000 Received: from Unknown (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 20 Sep 2015 22:36:55 +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 072FC1A279E for ; Sun, 20 Sep 2015 22:36:55 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 4.9 X-Spam-Level: **** X-Spam-Status: No, score=4.9 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, KAM_BADIPHTTP=2, SPF_PASS=-0.001, URIBL_BLOCKED=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-us-west.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id 4JllpSffJtI9 for ; Sun, 20 Sep 2015 22:36:48 +0000 (UTC) Received: from mail-lb0-f180.google.com (mail-lb0-f180.google.com [209.85.217.180]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id 284A02078F for ; Sun, 20 Sep 2015 22:36:48 +0000 (UTC) Received: by lbbvu2 with SMTP id vu2so43365094lbb.0 for ; Sun, 20 Sep 2015 15:36:40 -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 :content-type; bh=VqkP1rrVjyPKmBh6m6+j/s14s6nKuxjVqvO4bxq7yn4=; b=HpDtUbxRp2d0Zo1EJwLxj7aqH5Wm4N25snJULF6KbmTiwbEq4Vt2Yh/sn3ooNLqOXR o45FMtxw4N6Pxvng0/RW/Qnpw89aSVpaQ+5d+SBWqSOeFZMYwaSkbVzj+11Tlq6BXtFg cTfdpnJ3xwEG1sCMsI1Pd/o8i7gi0XScdjnP97HbnolUcjPUlibpn6rcRavcUONk9Uu0 0E5CIBqRXM4WEUhL0nA/HVmYhiXxqAYxaZHVCou5cji51prKorjEXdMhI4ZnYGLyLhmF DJ6HX+XBmyUMi0RWzjISCIlgT56KEXpAc+GYm5MghCwmzlZOv0akIG4/Sl+0wCo+/tZu qlEw== MIME-Version: 1.0 X-Received: by 10.152.6.133 with SMTP id b5mr6347974laa.98.1442788600165; Sun, 20 Sep 2015 15:36:40 -0700 (PDT) Received: by 10.112.211.168 with HTTP; Sun, 20 Sep 2015 15:36:40 -0700 (PDT) Received: by 10.112.211.168 with HTTP; Sun, 20 Sep 2015 15:36:40 -0700 (PDT) In-Reply-To: References: Date: Mon, 21 Sep 2015 01:36:40 +0300 Message-ID: Subject: Re: Field accessor not defined for values of type null From: Wail Alkowaileet To: users@asterixdb.incubator.apache.org Content-Type: multipart/alternative; boundary=089e01493fa8ffbc750520356520 --089e01493fa8ffbc750520356520 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I didn't test the last snapshot of AsterixDB. I remember reading somewhere that the new version can handle a record larger than a page. Sorry for not being helpful. On 21 Sep 2015 1:22 am, "Wail Alkowaileet" wrote: > I didn't encounter the same error. > > I did the following: > use dataverse exp; > drop dataset jpl if exists > drop type jplType if exists > create type jplType as open > { > fid:uuid > } > create dataset jpl(jplType) > primary key fid; > > load dataset jpl using localfs > (("path"=3D"127.0.0.1:///Users/wail/Dropbox > (MIT)/AsterixConnector/d-plus-m.adm"),("format"=3D"adm")); > > I only defined fid in my open jplType. However, I got different error: > "Unable to allocate frame larger than:255 bytes [HyracksDataException]" > > analysed_sst was too large for Hyracks to handle. After shrinking it, I > was able to load it. > > > > On Mon, Sep 21, 2015 at 12:23 AM, Malarout, Namrata (398M-Affiliate) < > Namrata.Malarout@jpl.nasa.gov> wrote: > >> Hi, >> I=E2=80=99ve attached a text file containing the schema. It isn=E2=80=99= t very detailed >> as of now. I want to see how long it takes for the data to get ingested. >> Here a link to the data: >> >> https://drive.google.com/file/d/0B6wmo4_-H0P2UUhJcFpVdWdZT1k/view?usp=3D= sharing >> It is one record from the sample data. I tried to attach it but it faile= d >> while sending a couple of times. >> Thanks, >> Namrata >> >> From: Wail Alkowaileet >> Reply-To: "users@asterixdb.incubator.apache.org" < >> users@asterixdb.incubator.apache.org> >> Date: Sunday, September 20, 2015 at 2:03 PM >> >> To: "users@asterixdb.incubator.apache.org" < >> users@asterixdb.incubator.apache.org> >> Subject: Re: Field accessor not defined for values of type null >> >> Hi, >> Can you please provide me the full schema and an example of the data? >> I want to replicate the error >> >> Thanks! >> >> On Sun, Sep 20, 2015 at 11:44 PM, Malarout, Namrata (398M-Affiliate) < >> Namrata.Malarout@jpl.nasa.gov> wrote: >> >>> Hi, >>> I was just trying to load the .adm file. This was my query: >>> >>> use dataverse TestL4; >>> >>> load dataset GlobL4 using localfs >>> >>> >>> (("path"=3D"LMC-015412:///Users/malarout/Desktop/d-plus-m.adm"),("forma= t"=3D"adm")); >>> >>> Thanks, >>> >>> Namrata >>> >>> From: Wail Alkowaileet >>> Reply-To: "users@asterixdb.incubator.apache.org" < >>> users@asterixdb.incubator.apache.org> >>> Date: Sunday, September 20, 2015 at 1:35 PM >>> To: "users@asterixdb.incubator.apache.org" < >>> users@asterixdb.incubator.apache.org> >>> Subject: Re: Field accessor not defined for values of type null >>> >>> Hi Namrata, >>> What was your query? >>> >>> Thanks! >>> >>> On Sun, Sep 20, 2015 at 11:12 PM, Malarout, Namrata (398M-Affiliate) < >>> Namrata.Malarout@jpl.nasa.gov> wrote: >>> >>>> Hi all, >>>> I am trying to load data into AsterixDB. But I keep getting this error= : >>>> >>>> Field accessor is not defined for values of type null [AlgebricksExcep= tion] >>>> >>>> This is the data, (1,291) is the position where the axis starts: >>>> "comment":"","axis":"T" >>>> I changed the blank field to null. So now the data >>>> is: "comment":null,"axis":=E2=80=9DT" >>>> But I=E2=80=99m still getting the same error. In the schema comment ha= s been >>>> declared as comment:string? . I=E2=80=99ve made it optional. Is there = something >>>> else that I need to take care of? What does is a field accessor? >>>> Thank in advance for the help. >>>> Regards, >>>> Namrata Malarout >>>> >>>> >>> >>> >>> -- >>> >>> *Regards,* >>> Wail Alkowaileet >>> >> >> >> >> -- >> >> *Regards,* >> Wail Alkowaileet >> > > > > -- > > *Regards,* > Wail Alkowaileet > --089e01493fa8ffbc750520356520 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

I didn't test the last snapshot of AsterixDB.
I remember reading somewhere that the new version can handle a record large= r than a page.

Sorry for not being helpful.

On 21 Sep 2015 1:22 am, "Wail Alkowaileet&q= uot; <wael.y.k@gmail.com> w= rote:
I didn't encounter the same error.

I did the foll= owing:
use dataverse exp;
drop dataset jpl if exis= ts
drop type jplType if exists
create type jplType as o= pen
{
=C2=A0 =C2=A0 fid:uuid
}
crea= te dataset jpl(jplType)
primary key fid;

load dataset jpl using localfs
=C2=A0 =C2=A0 (("path"= =3D"127.0.0.1:///Us= ers/wail/Dropbox (MIT)/AsterixConnector/d-plus-m.adm"),("format&q= uot;=3D"adm"));

I only defined fid= in my open jplType. However, I got different error:
"Unable to a= llocate frame larger than:255 bytes [HyracksDataException]"

analysed_sst was too large for Hyracks to handle. After shrinking = it, I was able to load it.



On Mon, Sep 21, 2015= at 12:23 AM, Malarout, Namrata (398M-Affiliate) <Namrata.Mala= rout@jpl.nasa.gov> wrote:
Hi,
I=E2=80=99ve attached a text file containing the schema. It isn=E2=80= =99t very detailed as of now. I want to see how long it takes for the data = to get ingested. Here a link to the data:
It is one record from the sample data. I tried to attach it but it fai= led while sending a couple of times.
Thanks,
Namrata

From: Wail Alkowaileet <wael.y.k@gmail.com>=
Reply-To: "users@asterixdb.incu= bator.apache.org" <users@asterixdb.incubator.apache.org><= br> Date: Sunday, September 20, = 2015 at 2:03 PM

To: "users@asterixdb.incubator.= apache.org" <users@asterixdb.incubator.apache.org>
Subject: Re: Field accessor not def= ined for values of type null

Hi,
Can you please provide me the full schema and an example of the data?<= /div>
I want to replicate the error

Thanks!

On Sun, Sep 20, 2015 at 11:44 PM, Malarout, Namr= ata (398M-Affiliate) <Namrata.Malarout@jpl.nasa.gov> wrote:
Hi,
I was just try= ing to load the .adm file. This was my query:

use dataverse TestL4;

load dataset GlobL4 using localfs

=C2=A0=C2=A0=C2=A0 (("path&= quot;=3D"LMC-015412:///Users/malarout/Desktop/d-plus-m.adm"),(&qu= ot;format"=3D"adm"));

Thanks,

Namrata


From: Wail Alkowaileet <wael.y.k@gmail.com>=
Reply-To: "users@asterixdb.incu= bator.apache.org" <users@asterixdb.incubator.apache.org><= br> Date: Sunday, September 20, 2015 at= 1:35 PM
To: "users@asterixdb.incubator.= apache.org" <users@asterixdb.incubator.apache.org>
Subject: Re: Field accessor not def= ined for values of type null

Hi Namrata,
What was your query?=C2=A0

Thanks!

On Sun, Sep 20, 2015 at 11:12 PM, Malarout, Namr= ata (398M-Affiliate) <Namrata.Malarout@jpl.nasa.gov> wrote:
Hi all,
I am trying to load data into AsterixDB. But I keep getting this error= :
Field accessor is not defined for values of type nul=
l [AlgebricksException]
This is the data, (1,291) is the position where the axis starts: "= ;comment":"","axis":"T"
I changed the blank field to null. So now the data is:=C2=A0"comm= ent":null,"axis":=E2=80=9DT"
But I=E2=80=99m still getting the same error. In the schema comment ha= s been declared as comment:string? . I=E2=80=99ve made it optional. Is ther= e something else that I need to take care of? What does is a field accessor= ?
Thank in advance for the help.
Regards,
Namrata Malarout




--

Regards,
Wail Alkowaileet



--

Regards,
Wail Alkowaileet



--

= Regards,
Wail Alkowaileet
--089e01493fa8ffbc750520356520--