[jira] [Created] (ASTERIXDB-1715) Clause spelled incorrectly in SQL++ documentation

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1715:
--

 Summary: Clause spelled incorrectly in SQL++ documentation
 Key: ASTERIXDB-1715
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1715
 Project: Apache AsterixDB
  Issue Type: Bug
  Components: Documentation
Reporter: Vignesh Raghunathan


Under the Group variables section, clause is spelled wrong in the sentence "We 
can use a subquery in the SELECT clase to tunnel through the extra nesting and 
produce the desired result."



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Closed] (ASTERIXDB-1712) Can't select fields if query contains union all clause with select * in from clause

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan closed ASTERIXDB-1712.
--
Resolution: Duplicate

> Can't select fields if query contains union all clause with select * in from 
> clause
> ---
>
> Key: ASTERIXDB-1712
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1712
> Project: Apache AsterixDB
>  Issue Type: Bug
>Reporter: Vignesh Raghunathan
>
> Consider the following sql++ statements:
> {code}
> drop dataverse sampdb if exists;
> create dataverse sampdb;
> use sampdb;
> create type samptabletype as closed {
>   id: int8
> };
> create dataset samptable1(samptabletype) primary key id;
> insert into samptable1 ({'id' : 1});
> insert into samptable1 ({'id' : 2});
> insert into samptable1 ({'id' : 3});
> create dataset samptable2(samptabletype) primary key id;
> insert into samptable2 ({'id' : 1});
> insert into samptable2 ({'id' : 2});
> insert into samptable2 ({'id' : 3});
> select *
> from 
> (select * from samptable1
> union all
> select * from samptable2
> ) tab1;
> {code}
> The result is:
> {code}
> { "tab1": { "samptable2": { "id": 1 } } }
> { "tab1": { "samptable2": { "id": 2 } } }
> { "tab1": { "samptable1": { "id": 1 } } }
> { "tab1": { "samptable1": { "id": 2 } } }
> { "tab1": { "samptable2": { "id": 3 } } }
> { "tab1": { "samptable1": { "id": 3 } } }
> {code}
> However, there is no way to express the following query to display only ids:
> select tab1.samptable(1/2 ??).id 
> from 
> (select * from samptable1
> union all
> select * from samptable2
> ) tab1;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (ASTERIXDB-1712) Can't select fields if query contains union all clause with select * in from clause

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1712:
--

 Summary: Can't select fields if query contains union all clause 
with select * in from clause
 Key: ASTERIXDB-1712
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1712
 Project: Apache AsterixDB
  Issue Type: Bug
Reporter: Vignesh Raghunathan


Consider the following sql++ statements:

{code}
drop dataverse sampdb if exists;
create dataverse sampdb;
use sampdb;

create type samptabletype as closed {
  id: int8
};

create dataset samptable1(samptabletype) primary key id;

insert into samptable1 ({'id' : 1});
insert into samptable1 ({'id' : 2});
insert into samptable1 ({'id' : 3});

create dataset samptable2(samptabletype) primary key id;

insert into samptable2 ({'id' : 1});
insert into samptable2 ({'id' : 2});
insert into samptable2 ({'id' : 3});

select *
from 
(select * from samptable1
union all
select * from samptable2
) tab1;
{code}

The result is:

{code}
{ "tab1": { "samptable2": { "id": 1 } } }
{ "tab1": { "samptable2": { "id": 2 } } }
{ "tab1": { "samptable1": { "id": 1 } } }
{ "tab1": { "samptable1": { "id": 2 } } }
{ "tab1": { "samptable2": { "id": 3 } } }
{ "tab1": { "samptable1": { "id": 3 } } }
{code}

However, there is no way to express the following query to display only ids:

select tab1.samptable(1/2 ??).id 
from 
(select * from samptable1
union all
select * from samptable2
) tab1;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (ASTERIXDB-1713) Can't select fields if query contains union all clause with select * in from clause

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1713:
--

 Summary: Can't select fields if query contains union all clause 
with select * in from clause
 Key: ASTERIXDB-1713
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1713
 Project: Apache AsterixDB
  Issue Type: Bug
Reporter: Vignesh Raghunathan


Consider the following sql++ statements:

{code}
drop dataverse sampdb if exists;
create dataverse sampdb;
use sampdb;

create type samptabletype as closed {
  id: int8
};

create dataset samptable1(samptabletype) primary key id;

insert into samptable1 ({'id' : 1});
insert into samptable1 ({'id' : 2});
insert into samptable1 ({'id' : 3});

create dataset samptable2(samptabletype) primary key id;

insert into samptable2 ({'id' : 1});
insert into samptable2 ({'id' : 2});
insert into samptable2 ({'id' : 3});

select *
from 
(select * from samptable1
union all
select * from samptable2
) tab1;
{code}

The result is:

{code}
{ "tab1": { "samptable2": { "id": 1 } } }
{ "tab1": { "samptable2": { "id": 2 } } }
{ "tab1": { "samptable1": { "id": 1 } } }
{ "tab1": { "samptable1": { "id": 2 } } }
{ "tab1": { "samptable2": { "id": 3 } } }
{ "tab1": { "samptable1": { "id": 3 } } }
{code}

However, there is no way to express the following query to display only ids:

select tab1.samptable(1/2 ??).id 
from 
(select * from samptable1
union all
select * from samptable2
) tab1;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (ASTERIXDB-1697) Joining results of with throws NullPointerException

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan updated ASTERIXDB-1697:
---
Attachment: my_asterix_nc2.log
my_asterix_nc1.log
cc.log

> Joining results of with throws NullPointerException
> ---
>
> Key: ASTERIXDB-1697
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1697
> Project: Apache AsterixDB
>  Issue Type: Bug
>Reporter: Vignesh Raghunathan
> Attachments: cc.log, my_asterix_nc1.log, my_asterix_nc2.log
>
>
> To reproduce the issue, run the following sql++ statements:
> {code}
> drop dataverse sampdb if exists;
> create dataverse sampdb;
> use sampdb;
> drop dataset samptable if exists;
> drop type samptabletype if exists;
> create type samptabletype as closed {
>   id: int8
> };
> create dataset samptable1(samptabletype) primary key id;
> insert into samptable1 ({'id' : 1});
> insert into samptable1 ({'id' : 2});
> insert into samptable1 ({'id' : 3});
> create dataset samptable2(samptabletype) primary key id;
> insert into samptable2 ({'id' : 1});
> insert into samptable2 ({'id' : 2});
> insert into samptable2 ({'id' : 3});
> drop dataset jointable if exists;
> drop type jointabletype if exists;
> create type jointabletype as closed {
>   id: int8
> };
> create dataset jointable(jointabletype) primary key id;
> insert into jointable ({'id' : 0});
> insert into jointable ({'id' : 1});
> with samptab1 as (
> select id
> from samptable1
> ),
> samptab2 as (
> select id 
> from samptable2
> )
> select *
> from
> jointable as jt1
> left outer join 
> samptab1 as st1
> on jt1.id = 0
> left outer join
> samptab2 as st2
> on jt1.id = 1
> or st1.id = st2.id
> left outer join
> samptab1 as st12
> on jt1.id = 1
> or st12.id = st2.id;
> {code}
> Please see the attached logs



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (ASTERIXDB-1692) Case statement referring to aggregated value throws ArrayIndexOutOfBoundsException

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1692:
--

 Summary: Case statement referring to aggregated value throws 
ArrayIndexOutOfBoundsException
 Key: ASTERIXDB-1692
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1692
 Project: Apache AsterixDB
  Issue Type: Bug
 Environment: Master branch with latest commit 
76a4f9e36e841d9325bedb3bb96e7
Reporter: Vignesh Raghunathan


To reproduce the issue, run the following SQL++ statements:

{code}
drop dataverse sampdb if exists;
create dataverse sampdb;
use sampdb;

create type samptabletype as closed {
  id1: int8,
  id2:int8?
};

create dataset samptable1(samptabletype) primary key id1;

insert into samptable1 ({'id1' : 1, 'id2':5});
insert into samptable1 ({'id1' : 2, 'id2':10});

with st1 as (
select id1, sum(id2) id2sum
from samptable1
group by id1)
select *
from st1
where (case when id2sum > 5 then (id2sum/id2sum) = 1 else true end);
{code}

Result:

{code}
4 [ArrayIndexOutOfBoundsException]
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (ASTERIXDB-1676) Query with aggregate functions in with and where clause doesn't return result

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15550990#comment-15550990
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1676:


This isn't reproducible anymore. Something should have been wrong with my setup

> Query with aggregate functions in with and where clause doesn't return result
> -
>
> Key: ASTERIXDB-1676
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1676
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Master branch with latest commit c21de4d89a06726851ea9a54
>Reporter: Vignesh Raghunathan
>Assignee: Yingyi Bu
>
> To reproduce the issue, run the following sql++ statements:
> {code}
> drop dataverse tpcds if exists;
> create dataverse tpcds;
> use tpcds;
> create type tpcds.store_returns_type as
>  closed {
>   sr_customer_sk : int64,
>   sr_fee : double?
> }
> create dataset store_returns (store_returns_type) primary key sr_customer_sk;
> with customer_total_return as
> (select sr_customer_sk as ctr_customer_sk
> ,sum(sr_fee) as ctr_total_return
> from store_returns
> group by sr_customer_sk)
> select  ctr_customer_sk
> from customer_total_return ctr1
> where ctr1.ctr_total_return > (
> select value (avg(ctr2.ctr_total_return)*1.2)
> from customer_total_return ctr2
> where ctr1.ctr_store_sk = ctr2.ctr_store_sk)[0]
> limit 1;
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (ASTERIXDB-1676) Query with aggregate functions in with and where clause doesn't return result

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1676:
--

 Summary: Query with aggregate functions in with and where clause 
doesn't return result
 Key: ASTERIXDB-1676
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1676
 Project: Apache AsterixDB
  Issue Type: Bug
 Environment: Master branch with latest commit c21de4d89a06726851ea9a54
Reporter: Vignesh Raghunathan


To reproduce the issue, run the following sql++ statements:

{code}
drop dataverse tpcds if exists;
create dataverse tpcds;

use tpcds;

create type tpcds.store_returns_type as
 closed {
  sr_customer_sk : int64,
  sr_fee : double?
}

create dataset store_returns (store_returns_type) primary key sr_customer_sk;

with customer_total_return as
(select sr_customer_sk as ctr_customer_sk
,sum(sr_fee) as ctr_total_return
from store_returns
group by sr_customer_sk)

select  ctr_customer_sk
from customer_total_return ctr1
where ctr1.ctr_total_return > (
select value (avg(ctr2.ctr_total_return)*1.2)
from customer_total_return ctr2
where ctr1.ctr_store_sk = ctr2.ctr_store_sk)[0]
limit 1;
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (ASTERIXDB-1632) Query having subquery referring to with clause returns incorrect results

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1632:
--

 Summary: Query having subquery referring to with clause returns 
incorrect results
 Key: ASTERIXDB-1632
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1632
 Project: Apache AsterixDB
  Issue Type: Bug
 Environment: Master branch with latest commit 2b95d9ac95aa6f4dd847
Reporter: Vignesh Raghunathan


To reproduce the issue, run the following sqlpp statements:

{code}
drop dataverse sampdb if exists;
create dataverse sampdb;
use sampdb;

drop dataset samptable if exists;
drop type samptabletype if exists;

create type samptabletype as closed {
  id: int8
};

create dataset samptable(samptabletype) primary key id;

insert into samptable ({'id' : 1});
insert into samptable ({'id' : 2});
insert into samptable ({'id' : 3});

with samptab as (
select id from samptable
)
select st1.id 
from samptab st1
where st1.id > (select value avg(st2.id) from samptab st2);
{code}

The query doesn't return {id:3}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Closed] (ASTERIXDB-1580) Subquery in having clause throws ArrayIndexOutOfBoundsException

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan closed ASTERIXDB-1580.
--
Resolution: Fixed

> Subquery in having clause throws ArrayIndexOutOfBoundsException
> ---
>
> Key: ASTERIXDB-1580
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1580
> Project: Apache AsterixDB
>  Issue Type: Bug
>Reporter: Vignesh Raghunathan
>Assignee: Yingyi Bu
> Attachments: logs.zip
>
>
> The following sqlpp query throws an ArrayIndexOutOfBoundsException
> {code}
> use tpcds;
> select  a.ca_state state, count(a) cnt
>  from customer_address a
>  ,customer c
>  ,store_sales s
>  ,date_dim d
>  ,item i
>  where  a.ca_address_sk = c.c_current_addr_sk
>   and c.c_customer_sk = s.ss_customer_sk
>   and s.ss_sold_date_sk = d.d_date_sk
>   and s.ss_item_sk = i.i_item_sk
>  group by a.ca_state group as stategrp
>  having coll_count((select value a from stategrp)) >= 10
>  order by cnt
>  limit 100;
> {code}
> tpcdsq6.zip contains the schema and data for the datasets used in the query



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (ASTERIXDB-1600) Support for date arthimetic

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan updated ASTERIXDB-1600:
---
Description: 
{code}
drop dataverse sampdb if exists;
create dataverse sampdb;
use sampdb;

drop dataset samptable if exists;
drop type samptabletype if exists;

create type samptabletype as closed {
  dt: date
};

create type samptabletype2 as closed {
  id: int64,
  firstname: string,
  lastname: string
};

create dataset samptable(samptabletype) primary key dt;

create dataset samptable2(samptabletype2) primary key id;

select *
from samptable s1, samptable s2
where s1.dt > s2.dt + 5;

select firstname + " " + lastname as fullname
from samptable2
{code}

The above queries can't be expressed in sqlpp without support for date and 
string type arithmetic.

  was:
{code}
drop dataverse sampdb if exists;
create dataverse sampdb;
use sampdb;

drop dataset samptable if exists;
drop type samptabletype if exists;

create type samptabletype as closed {
  dt: date
};

create dataset samptable(samptabletype) primary key dt;

select *
from samptable s1, samptable s2
where s1.dt > s2.dt + 5;
{code}

The above query can't be expressed in sqlpp without support for date type 
arithmetic.


> Support for date arthimetic
> ---
>
> Key: ASTERIXDB-1600
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1600
> Project: Apache AsterixDB
>  Issue Type: Improvement
>Reporter: Vignesh Raghunathan
>
> {code}
> drop dataverse sampdb if exists;
> create dataverse sampdb;
> use sampdb;
> drop dataset samptable if exists;
> drop type samptabletype if exists;
> create type samptabletype as closed {
>   dt: date
> };
> create type samptabletype2 as closed {
>   id: int64,
>   firstname: string,
>   lastname: string
> };
> create dataset samptable(samptabletype) primary key dt;
> create dataset samptable2(samptabletype2) primary key id;
> select *
> from samptable s1, samptable s2
> where s1.dt > s2.dt + 5;
> select firstname + " " + lastname as fullname
> from samptable2
> {code}
> The above queries can't be expressed in sqlpp without support for date and 
> string type arithmetic.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (ASTERIXDB-1602) Nested subqueries in with clause throws StackOverflowError

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan updated ASTERIXDB-1602:
---
Attachment: tpcdsadb.txt
adblog.txt

> Nested subqueries in with clause throws StackOverflowError
> --
>
> Key: ASTERIXDB-1602
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1602
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Master branch with latest change id 
> I363df794c48644ca806958f583a05aea10a93166
>Reporter: Vignesh Raghunathan
> Attachments: adblog.txt, tpcdsadb.txt
>
>
> To reproduce the issue, run the following sqlpp query after creating datasets 
> using tpcdsadb.txt
> {code}
> use tpcds;
> with tab as
>  (select *
>  from item,
>   date_dim d1
>   where d1.d_datein
>   (select d2.d_date
>   from date_dim d2
>   where d2.d_week_seq in
>   (select d3.d_week_seq
>   from date_dim d3
> where d3.d_date in 
> [date('1998-01-02'),date('1998-10-15'),date('1998-11-10')]))
>  group by i_item_id)
>   select  *
>  from tab t1, tab t2;
> {code}
> Result:
> Please check adblog.txt



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (ASTERIXDB-1602) Nested subqueries in with clause throws StackOverflowError

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan updated ASTERIXDB-1602:
---
Summary: Nested subqueries in with clause throws StackOverflowError  (was: 
Nest subqueries in with clause throws StackOverflowError)

> Nested subqueries in with clause throws StackOverflowError
> --
>
> Key: ASTERIXDB-1602
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1602
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Master branch with latest change id 
> I363df794c48644ca806958f583a05aea10a93166
>Reporter: Vignesh Raghunathan
> Attachments: adblog.txt, tpcdsadb.txt
>
>
> To reproduce the issue, run the following sqlpp query after creating datasets 
> using tpcdsadb.txt
> {code}
> use tpcds;
> with tab as
>  (select *
>  from item,
>   date_dim d1
>   where d1.d_datein
>   (select d2.d_date
>   from date_dim d2
>   where d2.d_week_seq in
>   (select d3.d_week_seq
>   from date_dim d3
> where d3.d_date in 
> [date('1998-01-02'),date('1998-10-15'),date('1998-11-10')]))
>  group by i_item_id)
>   select  *
>  from tab t1, tab t2;
> {code}
> Result:
> Please check adblog.txt



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (ASTERIXDB-1602) Nest subqueries in with clause throws StackOverflowError

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1602:
--

 Summary: Nest subqueries in with clause throws StackOverflowError
 Key: ASTERIXDB-1602
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1602
 Project: Apache AsterixDB
  Issue Type: Bug
 Environment: Master branch with latest change id 
I363df794c48644ca806958f583a05aea10a93166
Reporter: Vignesh Raghunathan


To reproduce the issue, run the following sqlpp query after creating datasets 
using tpcdsadb.txt

{code}
use tpcds;

with tab as
 (select *
 from item,
  date_dim d1
  where d1.d_datein
(select d2.d_date
from date_dim d2
where d2.d_week_seq in
(select d3.d_week_seq
from date_dim d3
  where d3.d_date in 
[date('1998-01-02'),date('1998-10-15'),date('1998-11-10')]))
 group by i_item_id)
  select  *
 from tab t1, tab t2;
{code}

Result:

Please check adblog.txt



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (ASTERIXDB-1600) Support for date arthimetic

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1600:
--

 Summary: Support for date arthimetic
 Key: ASTERIXDB-1600
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1600
 Project: Apache AsterixDB
  Issue Type: Improvement
Reporter: Vignesh Raghunathan


{code}
drop dataverse sampdb if exists;
create dataverse sampdb;
use sampdb;

drop dataset samptable if exists;
drop type samptabletype if exists;

create type samptabletype as closed {
  dt: date
};

create dataset samptable(samptabletype) primary key dt;

select *
from samptable s1, samptable s2
where s1.dt > s2.dt + 5;
{code}

The above query can't be expressed in sqlpp without support for date type 
arithmetic.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Reopened] (ASTERIXDB-1580) Subquery in having clause throws ArrayIndexOutOfBoundsException

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan reopened ASTERIXDB-1580:


> Subquery in having clause throws ArrayIndexOutOfBoundsException
> ---
>
> Key: ASTERIXDB-1580
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1580
> Project: Apache AsterixDB
>  Issue Type: Bug
>Reporter: Vignesh Raghunathan
>Assignee: Yingyi Bu
> Attachments: logs.zip
>
>
> The following sqlpp query throws an ArrayIndexOutOfBoundsException
> {code}
> use tpcds;
> select  a.ca_state state, count(a) cnt
>  from customer_address a
>  ,customer c
>  ,store_sales s
>  ,date_dim d
>  ,item i
>  where  a.ca_address_sk = c.c_current_addr_sk
>   and c.c_customer_sk = s.ss_customer_sk
>   and s.ss_sold_date_sk = d.d_date_sk
>   and s.ss_item_sk = i.i_item_sk
>  group by a.ca_state group as stategrp
>  having coll_count((select value a from stategrp)) >= 10
>  order by cnt
>  limit 100;
> {code}
> tpcdsq6.zip contains the schema and data for the datasets used in the query



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (ASTERIXDB-1597) Ordering by aggregated field throws NullPointerException

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1597:
--

 Summary: Ordering by aggregated field throws NullPointerException
 Key: ASTERIXDB-1597
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1597
 Project: Apache AsterixDB
  Issue Type: Bug
 Environment: Master branch with latest commit 
0339b475f323e6e2777dbcb13ee2
Reporter: Vignesh Raghunathan


To reproduce the issue, run the following sqlpp statements:

{code}
drop dataverse sampdb if exists;
create dataverse sampdb;
use sampdb;

drop dataset samptable if exists;
drop type samptabletype if exists;

create type samptabletype as closed {
  id: int8
};

create dataset samptable1(samptabletype) primary key id;

insert into samptable1 ({'id' : 0});
insert into samptable1 ({'id' : 1});

select sumid
from (
select sum(id) sumid from samptable1 
) t1
order by sumid;
{code}

Result:

{code}
java.lang.NullPointerException
at 
org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.getActualType(TypeComputeUtils.java:174)
at 
org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.getActualType(TypeComputeUtils.java:153)
at 
org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.resolveResultType(TypeComputeUtils.java:84)
at 
org.apache.asterix.om.typecomputer.base.AbstractResultTypeComputer.computeType(AbstractResultTypeComputer.java:39)
at 
org.apache.asterix.dataflow.data.common.AqlExpressionTypeComputer.getTypeForFunction(AqlExpressionTypeComputer.java:80)
at 
org.apache.asterix.dataflow.data.common.AqlExpressionTypeComputer.getType(AqlExpressionTypeComputer.java:53)
at 
org.apache.hyracks.algebricks.core.algebra.typing.AbstractTypeEnvironment.getType(AbstractTypeEnvironment.java:45)
at 
org.apache.asterix.om.typecomputer.impl.OpenRecordConstructorResultType.computeType(OpenRecordConstructorResultType.java:70)
at 
org.apache.asterix.dataflow.data.common.AqlExpressionTypeComputer.getTypeForFunction(AqlExpressionTypeComputer.java:80)
at 
org.apache.asterix.dataflow.data.common.AqlExpressionTypeComputer.getType(AqlExpressionTypeComputer.java:53)
at 
org.apache.hyracks.algebricks.core.algebra.operators.logical.AssignOperator.computeOutputTypeEnvironment(AssignOperator.java:92)
at 
org.apache.asterix.optimizer.rules.IntroduceEnforcedListTypeRule.rewritePost(IntroduceEnforcedListTypeRule.java:79)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:126)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.compiler.rewriter.rulecontrollers.SequentialFixpointRuleController.rewriteWithRuleCollection(SequentialFixpointRuleController.java:53)
at 
org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.runOptimizationSets(HeuristicOptimizer.java:102)
at 
org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.optimize(HeuristicOptimizer.java:82)
at 
org.apache.hyracks.algebricks.compiler.api.HeuristicCompilerFactoryBuilder$1$1.optimize(HeuristicCompilerFactoryBuilder.java:90)
at 
org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:268)
at 
org.apache.asterix.aql.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1938)
at 
org.apache.asterix.aql.translator.QueryTranslator.handleQuery(QueryTranslator.java:2533)
at 
org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:365)
at 
org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:258)
at 
org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at 
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:845)
at 
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)
at 
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224)
at 
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)
at 
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
at 
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at 
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
at 
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at 

[jira] [Created] (ASTERIXDB-1592) Combining SQL-92 type join and left outer join throws NullPointerException

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1592:
--

 Summary: Combining SQL-92 type join and left outer join throws 
NullPointerException
 Key: ASTERIXDB-1592
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1592
 Project: Apache AsterixDB
  Issue Type: Bug
 Environment: Master branch with latest commit 
0339b475f323e6e2777dbcb13ee2
Reporter: Vignesh Raghunathan


To reproduce the issue, run the following sqlpp query after creating datasets 
using tpcdsadb.txt:

{code}
use tpcds;

select *
 from
   catalog_sales cs1
   left outer join
   catalog_returns cr1
   on (cs1.cs_order_number = cr1.cr_order_number
and cs1.cs_item_sk = cr1.cr_item_sk)
  ,item i1
 where
  i1.i_item_sk = cs1.cs_item_sk;
{code}

Result:

{code}
java.lang.NullPointerException
at 
org.apache.hyracks.algebricks.core.algebra.properties.LocalGroupingProperty.retainVariables(LocalGroupingProperty.java:88)
at 
org.apache.hyracks.algebricks.core.algebra.operators.physical.AbstractPropagatePropertiesForUsedVariablesPOperator.computeDeliveredPropertiesForUsedVariables(AbstractPropagatePropertiesForUsedVariablesPOperator.java:42)
at 
org.apache.hyracks.algebricks.core.algebra.operators.physical.StreamProjectPOperator.computeDeliveredProperties(StreamProjectPOperator.java:81)
at 
org.apache.hyracks.algebricks.core.algebra.operators.logical.AbstractLogicalOperator.computeDeliveredPhysicalProperties(AbstractLogicalOperator.java:131)
at 
org.apache.hyracks.algebricks.rewriter.rules.EnforceStructuralPropertiesRule.physOptimizeOp(EnforceStructuralPropertiesRule.java:214)
at 
org.apache.hyracks.algebricks.rewriter.rules.EnforceStructuralPropertiesRule.physOptimizeOp(EnforceStructuralPropertiesRule.java:211)
at 
org.apache.hyracks.algebricks.rewriter.rules.EnforceStructuralPropertiesRule.physOptimizeOp(EnforceStructuralPropertiesRule.java:211)
at 
org.apache.hyracks.algebricks.rewriter.rules.EnforceStructuralPropertiesRule.physOptimizeOp(EnforceStructuralPropertiesRule.java:211)
at 
org.apache.hyracks.algebricks.rewriter.rules.EnforceStructuralPropertiesRule.rewritePre(EnforceStructuralPropertiesRule.java:130)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:91)
at 
org.apache.hyracks.algebricks.compiler.rewriter.rulecontrollers.SequentialOnceRuleController.rewriteWithRuleCollection(SequentialOnceRuleController.java:44)
at 
org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.runOptimizationSets(HeuristicOptimizer.java:102)
at 
org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.runPhysicalOptimizations(HeuristicOptimizer.java:133)
at 
org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.optimize(HeuristicOptimizer.java:84)
at 
org.apache.hyracks.algebricks.compiler.api.HeuristicCompilerFactoryBuilder$1$1.optimize(HeuristicCompilerFactoryBuilder.java:90)
at 
org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:268)
at 
org.apache.asterix.aql.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1938)
at 
org.apache.asterix.aql.translator.QueryTranslator.handleQuery(QueryTranslator.java:2533)
at 
org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:365)
at 
org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:258)
at 
org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at 
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:845)
at 
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)
at 
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224)
at 
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)
at 
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
at 
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at 
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
at 
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at 
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
at org.eclipse.jetty.server.Server.handle(Server.java:524)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:319)
at 
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:253)
at 

[jira] [Updated] (ASTERIXDB-1591) Multiple exists in where throws NullPointerException

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan updated ASTERIXDB-1591:
---
Attachment: tpcdsadb.txt

> Multiple exists in where throws NullPointerException
> 
>
> Key: ASTERIXDB-1591
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1591
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Master branch with latest commit 
> 0339b475f323e6e2777dbcb13ee2
>Reporter: Vignesh Raghunathan
> Attachments: tpcdsadb.txt
>
>
> To reproduce the issue, run the following sqlpp query after creating datasets 
> using dml statements in tpcdsadb.txt:
> {code}
> use tpcds;
> select *
> from
>   customer c,customer_address ca,customer_demographics
>  where
>   c.c_current_addr_sk = ca.ca_address_sk and
>   cd_demo_sk = c.c_current_cdemo_sk and
>   exists (select *
>   from store_sales ss1,date_dim dd1
>   where c.c_customer_sk = ss1.ss_customer_sk and
> ss1.ss_sold_date_sk = dd1.d_date_sk and
> dd1.d_year = 1999 and
> dd1.d_qoy < 4) and
>(exists (select *
> from web_sales ws1,date_dim dd1
> where c.c_customer_sk = ws1.ws_bill_customer_sk and
>   ws1.ws_sold_date_sk = dd1.d_date_sk and
>   dd1.d_year = 1999 and
>   dd1.d_qoy < 4) or
> exists (select *
> from catalog_sales cs1,date_dim dd1
> where c.c_customer_sk = cs1.cs_ship_customer_sk and
>   cs1.cs_sold_date_sk = dd1.d_date_sk and
>   dd1.d_year = 1999 and
>   dd1.d_qoy < 4))
>   limit 100;
> {code}
> Result:
> {code}
> java.lang.NullPointerException
>   at 
> org.apache.asterix.metadata.declared.AqlMetadataProvider.buildBtreeRuntime(AqlMetadataProvider.java:659)
>   at 
> org.apache.asterix.metadata.declared.AqlMetadataProvider.buildInternalDatasetScan(AqlMetadataProvider.java:482)
>   at 
> org.apache.asterix.metadata.declared.AqlMetadataProvider.getScannerRuntime(AqlMetadataProvider.java:342)
>   at 
> org.apache.hyracks.algebricks.core.algebra.operators.physical.DataSourceScanPOperator.contributeRuntimeOperator(DataSourceScanPOperator.java:87)
>   at 
> org.apache.hyracks.algebricks.core.algebra.operators.logical.AbstractLogicalOperator.contributeRuntimeOperator(AbstractLogicalOperator.java:166)
>   at 
> org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:98)
>   at 
> org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
>   at 
> org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
>   at 
> org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
>   at 
> org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
>   at 
> org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
>   at 
> org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
>   at 
> org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
>   at 
> org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
>   at 
> org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
>   at 
> org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
>   at 
> org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compilePlan(PlanCompiler.java:61)
>   at 
> org.apache.hyracks.algebricks.core.algebra.operators.physical.AbstractPhysicalOperator.buildPipelineWithProjection(AbstractPhysicalOperator.java:136)
>   at 
> org.apache.hyracks.algebricks.core.algebra.operators.physical.AbstractPhysicalOperator.compileSubplans(AbstractPhysicalOperator.java:125)
>   at 
> org.apache.hyracks.algebricks.core.algebra.operators.physical.SubplanPOperator.contributeRuntimeOperator(SubplanPOperator.java:92)
>   at 
> org.apache.hyracks.algebricks.core.algebra.operators.logical.AbstractLogicalOperator.contributeRuntimeOperator(AbstractLogicalOperator.java:166)
>   at 
> org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:98)
>   at 
> org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
>   at 
> org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
>   at 
> org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
>   at 
> 

[jira] [Created] (ASTERIXDB-1591) Multiple exists in where throws NullPointerException

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1591:
--

 Summary: Multiple exists in where throws NullPointerException
 Key: ASTERIXDB-1591
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1591
 Project: Apache AsterixDB
  Issue Type: Bug
 Environment: Master branch with latest commit 
0339b475f323e6e2777dbcb13ee2
Reporter: Vignesh Raghunathan


To reproduce the issue, run the following sqlpp query after creating datasets 
using dml statements in tpcdsadb.txt:

{code}
use tpcds;

select *
from
  customer c,customer_address ca,customer_demographics
 where
  c.c_current_addr_sk = ca.ca_address_sk and
  cd_demo_sk = c.c_current_cdemo_sk and
  exists (select *
  from store_sales ss1,date_dim dd1
  where c.c_customer_sk = ss1.ss_customer_sk and
ss1.ss_sold_date_sk = dd1.d_date_sk and
dd1.d_year = 1999 and
dd1.d_qoy < 4) and
   (exists (select *
from web_sales ws1,date_dim dd1
where c.c_customer_sk = ws1.ws_bill_customer_sk and
  ws1.ws_sold_date_sk = dd1.d_date_sk and
  dd1.d_year = 1999 and
  dd1.d_qoy < 4) or
exists (select *
from catalog_sales cs1,date_dim dd1
where c.c_customer_sk = cs1.cs_ship_customer_sk and
  cs1.cs_sold_date_sk = dd1.d_date_sk and
  dd1.d_year = 1999 and
  dd1.d_qoy < 4))
  limit 100;
{code}

Result:

{code}
java.lang.NullPointerException
at 
org.apache.asterix.metadata.declared.AqlMetadataProvider.buildBtreeRuntime(AqlMetadataProvider.java:659)
at 
org.apache.asterix.metadata.declared.AqlMetadataProvider.buildInternalDatasetScan(AqlMetadataProvider.java:482)
at 
org.apache.asterix.metadata.declared.AqlMetadataProvider.getScannerRuntime(AqlMetadataProvider.java:342)
at 
org.apache.hyracks.algebricks.core.algebra.operators.physical.DataSourceScanPOperator.contributeRuntimeOperator(DataSourceScanPOperator.java:87)
at 
org.apache.hyracks.algebricks.core.algebra.operators.logical.AbstractLogicalOperator.contributeRuntimeOperator(AbstractLogicalOperator.java:166)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:98)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compilePlan(PlanCompiler.java:61)
at 
org.apache.hyracks.algebricks.core.algebra.operators.physical.AbstractPhysicalOperator.buildPipelineWithProjection(AbstractPhysicalOperator.java:136)
at 
org.apache.hyracks.algebricks.core.algebra.operators.physical.AbstractPhysicalOperator.compileSubplans(AbstractPhysicalOperator.java:125)
at 
org.apache.hyracks.algebricks.core.algebra.operators.physical.SubplanPOperator.contributeRuntimeOperator(SubplanPOperator.java:92)
at 
org.apache.hyracks.algebricks.core.algebra.operators.logical.AbstractLogicalOperator.contributeRuntimeOperator(AbstractLogicalOperator.java:166)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:98)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
at 
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:85)
at 

[jira] [Commented] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15426756#comment-15426756
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1546:


Yes, this could be resolved as not a problem

> Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
> 
>
> Key: ASTERIXDB-1546
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1546
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Eclipse IDE
> Version: Neon Release (4.6.0)
> Build id: 20160613-1800
>Reporter: Vignesh Raghunathan
>
> After launching an AsterixDB instance using 
> AsterixHyracksIntegrationUtil.java, the following exceptions are thrown after 
> a query like abs(-1) is executed.
> 2016-07-25 16:03:00,412 WARN  [qtp1833789138-36] util.log 
> (JCLLoggerAdapter.java:warn(437)) - Error for /
> java.lang.ExceptionInInitializerError
>   at 
> org.apache.asterix.translator.LangExpressionToPlanTranslator.(LangExpressionToPlanTranslator.java:177)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslator.(AqlExpressionToPlanTranslator.java:72)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslatorFactory.createExpressionToPlanTranslator(AqlExpressionToPlanTranslatorFactory.java:31)
>   at 
> org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:208)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1938)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.handleQuery(QueryTranslator.java:2534)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:365)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:258)
>   at 
> org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:130)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
>   at 
> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:546)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:483)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:228)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:956)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:411)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:188)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:891)
>   at 
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
>   at 
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
>   at org.eclipse.jetty.server.Server.handle(Server.java:353)
>   at 
> org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:598)
>   at 
> org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1076)
>   at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805)
>   at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218)
>   at 
> org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:427)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:510)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)
>   at 
> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:450)
>   at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.IllegalStateException: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at 
> org.apache.asterix.translator.util.FunctionCollection.getGeneratedFunctionDescriptorFactory(FunctionCollection.java:643)
>   at 
> org.apache.asterix.translator.util.FunctionCollection.(FunctionCollection.java:618)
>   ... 31 more
> Caused by: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
>   at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
>   at java.security.AccessController.doPrivileged(Native Method)
>   at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
>   at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>   at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
>   at 

[jira] [Updated] (ASTERIXDB-1581) Subquery inside case when clause - ConcurrentModificationException is thrown

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan updated ASTERIXDB-1581:
---
Attachment: tpcdsadb.txt

> Subquery inside case when clause - ConcurrentModificationException is thrown
> 
>
> Key: ASTERIXDB-1581
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1581
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Master branch with latest commit id: 
> bd3a535b171a5cc7486175
>Reporter: Vignesh Raghunathan
> Attachments: tpcdsadb.txt
>
>
> To reproduce the issue run the following sqlpp query after creating the types 
> and datasets in the attached file tpcdsadb:
> {code}
> select case when (select value count(ss)
>   from store_sales ss
>   where ss_quantity >= 1 and ss_quantity <= 20) > 25437
> then (select avg(ss_ext_discount_amt)
>   from store_sales
>   where ss_quantity >= 1 and ss_quantity <= 20)
> else (select avg(ss_net_profit)
>   from store_sales
>   where ss_quantity >= 1 and ss_quantity <= 20) end bucket1 
> from reason
> where r_reason_sk = 1;
> {code}
> Result:
> {code}
> java.util.ConcurrentModificationException
>   at java.util.HashMap$HashIterator.nextNode(HashMap.java:1429)
>   at java.util.HashMap$KeyIterator.next(HashMap.java:1453)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitAggregateOperator(InlineAllNtsInSubplanVisitor.java:640)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitAggregateOperator(InlineAllNtsInSubplanVisitor.java:183)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitAggregateOperator(InlineAllNtsInSubplanVisitor.java:126)
>   at 
> org.apache.hyracks.algebricks.core.algebra.operators.logical.AggregateOperator.accept(AggregateOperator.java:55)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitSingleInputOperator(InlineAllNtsInSubplanVisitor.java:690)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitAssignOperator(InlineAllNtsInSubplanVisitor.java:469)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitAssignOperator(InlineAllNtsInSubplanVisitor.java:126)
>   at 
> org.apache.hyracks.algebricks.core.algebra.operators.logical.AssignOperator.accept(AssignOperator.java:63)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitSingleInputOperator(InlineAllNtsInSubplanVisitor.java:690)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitAggregateOperator(InlineAllNtsInSubplanVisitor.java:635)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitAggregateOperator(InlineAllNtsInSubplanVisitor.java:183)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitAggregateOperator(InlineAllNtsInSubplanVisitor.java:126)
>   at 
> org.apache.hyracks.algebricks.core.algebra.operators.logical.AggregateOperator.accept(AggregateOperator.java:55)
>   at 
> org.apache.asterix.optimizer.rules.subplan.SubplanFlatteningUtil.inlineAllNestedTupleSource(SubplanFlatteningUtil.java:67)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.applyGeneralFlattening(InlineSubplanInputForNestedTupleSourceRule.java:351)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.rewriteSubplanOperator(InlineSubplanInputForNestedTupleSourceRule.java:291)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.traverseNonSubplanOperator(InlineSubplanInputForNestedTupleSourceRule.java:313)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.rewriteSubplanOperator(InlineSubplanInputForNestedTupleSourceRule.java:280)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.traverseNonSubplanOperator(InlineSubplanInputForNestedTupleSourceRule.java:313)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.rewriteSubplanOperator(InlineSubplanInputForNestedTupleSourceRule.java:280)
>   at 
> org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.traverseNonSubplanOperator(InlineSubplanInputForNestedTupleSourceRule.java:313)
>   at 
> 

[jira] [Created] (ASTERIXDB-1581) Subquery inside case when clause - ConcurrentModificationException is thrown

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1581:
--

 Summary: Subquery inside case when clause - 
ConcurrentModificationException is thrown
 Key: ASTERIXDB-1581
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1581
 Project: Apache AsterixDB
  Issue Type: Bug
 Environment: Master branch with latest commit id: 
bd3a535b171a5cc7486175
Reporter: Vignesh Raghunathan


To reproduce the issue run the following sqlpp query after creating the types 
and datasets in the attached file tpcdsadb:

{code}
select case when (select value count(ss)
  from store_sales ss
  where ss_quantity >= 1 and ss_quantity <= 20) > 25437
then (select avg(ss_ext_discount_amt)
  from store_sales
  where ss_quantity >= 1 and ss_quantity <= 20)
else (select avg(ss_net_profit)
  from store_sales
  where ss_quantity >= 1 and ss_quantity <= 20) end bucket1 
from reason
where r_reason_sk = 1;
{code}

Result:

{code}
java.util.ConcurrentModificationException
at java.util.HashMap$HashIterator.nextNode(HashMap.java:1429)
at java.util.HashMap$KeyIterator.next(HashMap.java:1453)
at 
org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitAggregateOperator(InlineAllNtsInSubplanVisitor.java:640)
at 
org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitAggregateOperator(InlineAllNtsInSubplanVisitor.java:183)
at 
org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitAggregateOperator(InlineAllNtsInSubplanVisitor.java:126)
at 
org.apache.hyracks.algebricks.core.algebra.operators.logical.AggregateOperator.accept(AggregateOperator.java:55)
at 
org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitSingleInputOperator(InlineAllNtsInSubplanVisitor.java:690)
at 
org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitAssignOperator(InlineAllNtsInSubplanVisitor.java:469)
at 
org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitAssignOperator(InlineAllNtsInSubplanVisitor.java:126)
at 
org.apache.hyracks.algebricks.core.algebra.operators.logical.AssignOperator.accept(AssignOperator.java:63)
at 
org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitSingleInputOperator(InlineAllNtsInSubplanVisitor.java:690)
at 
org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitAggregateOperator(InlineAllNtsInSubplanVisitor.java:635)
at 
org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitAggregateOperator(InlineAllNtsInSubplanVisitor.java:183)
at 
org.apache.asterix.optimizer.rules.subplan.InlineAllNtsInSubplanVisitor.visitAggregateOperator(InlineAllNtsInSubplanVisitor.java:126)
at 
org.apache.hyracks.algebricks.core.algebra.operators.logical.AggregateOperator.accept(AggregateOperator.java:55)
at 
org.apache.asterix.optimizer.rules.subplan.SubplanFlatteningUtil.inlineAllNestedTupleSource(SubplanFlatteningUtil.java:67)
at 
org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.applyGeneralFlattening(InlineSubplanInputForNestedTupleSourceRule.java:351)
at 
org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.rewriteSubplanOperator(InlineSubplanInputForNestedTupleSourceRule.java:291)
at 
org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.traverseNonSubplanOperator(InlineSubplanInputForNestedTupleSourceRule.java:313)
at 
org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.rewriteSubplanOperator(InlineSubplanInputForNestedTupleSourceRule.java:280)
at 
org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.traverseNonSubplanOperator(InlineSubplanInputForNestedTupleSourceRule.java:313)
at 
org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.rewriteSubplanOperator(InlineSubplanInputForNestedTupleSourceRule.java:280)
at 
org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.traverseNonSubplanOperator(InlineSubplanInputForNestedTupleSourceRule.java:313)
at 
org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.rewriteSubplanOperator(InlineSubplanInputForNestedTupleSourceRule.java:280)
at 
org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.traverseNonSubplanOperator(InlineSubplanInputForNestedTupleSourceRule.java:313)
at 

[jira] [Commented] (ASTERIXDB-1580) Subquery in having clause throws ArrayIndexOutOfBoundsException

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15421070#comment-15421070
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1580:


I have sent tpcdsq6.zip to [~buyingyi]. It couldn't be attached here due to its 
size.

> Subquery in having clause throws ArrayIndexOutOfBoundsException
> ---
>
> Key: ASTERIXDB-1580
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1580
> Project: Apache AsterixDB
>  Issue Type: Bug
>Reporter: Vignesh Raghunathan
> Attachments: logs.zip
>
>
> The following sqlpp query throws an ArrayIndexOutOfBoundsException
> {code}
> use tpcds;
> select  a.ca_state state, count(a) cnt
>  from customer_address a
>  ,customer c
>  ,store_sales s
>  ,date_dim d
>  ,item i
>  where  a.ca_address_sk = c.c_current_addr_sk
>   and c.c_customer_sk = s.ss_customer_sk
>   and s.ss_sold_date_sk = d.d_date_sk
>   and s.ss_item_sk = i.i_item_sk
>  group by a.ca_state group as stategrp
>  having coll_count((select value a from stategrp)) >= 10
>  order by cnt
>  limit 100;
> {code}
> tpcdsq6.zip contains the schema and data for the datasets used in the query



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (ASTERIXDB-1580) Subquery in having clause throws ArrayIndexOutOfBoundsException

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1580:
--

 Summary: Subquery in having clause throws 
ArrayIndexOutOfBoundsException
 Key: ASTERIXDB-1580
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1580
 Project: Apache AsterixDB
  Issue Type: Bug
Reporter: Vignesh Raghunathan


The following sqlpp query throws an ArrayIndexOutOfBoundsException

{code}
use tpcds;

select  a.ca_state state, count(a) cnt
 from customer_address a
 ,customer c
 ,store_sales s
 ,date_dim d
 ,item i
 where  a.ca_address_sk = c.c_current_addr_sk
and c.c_customer_sk = s.ss_customer_sk
and s.ss_sold_date_sk = d.d_date_sk
and s.ss_item_sk = i.i_item_sk
 group by a.ca_state group as stategrp
 having coll_count((select value a from stategrp)) >= 10
 order by cnt
 limit 100;
{code}

tpcdsq6.zip contains the schema and data for the datasets used in the query



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (ASTERIXDB-1574) Result of subquery in where clause could not be cast to a scalar value

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1574?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419918#comment-15419918
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1574:


Another query:

select samptable.id
from samptable
where samptable.id in [(select value id from samptable)];

> Result of subquery in where clause could not be cast to a scalar value
> --
>
> Key: ASTERIXDB-1574
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1574
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Master branch with latest commit id: 
> bd3a535b171a5cc7486175
>Reporter: Vignesh Raghunathan
>Assignee: Yingyi Bu
>
> To reproduce the issue, run the following sqlpp statements:
> {code}
> drop dataverse sampdb if exists;
> create dataverse sampdb;
> use sampdb;
> drop dataset samptable if exists;
> drop type samptabletype if exists;
> create type samptabletype as closed {
>   id: int64
> };
> create dataset samptable(samptabletype) primary key id;
> insert into samptable ({'id' : 1});
> insert into samptable ({'id' : 2});
> insert into samptable ({'id' : 3});
> insert into samptable ({'id' : 4});
> insert into samptable ({'id' : 5});
> select *
> from samptable 
> where id > (select value avg(id) from samptable)[0];
> {code}
> Result:
> {code}
> org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: The 
> input type for input argument 0(ARecord) is not expected.
>   at 
> org.apache.asterix.om.typecomputer.impl.CollectionMemberResultType.checkArgType(CollectionMemberResultType.java:40)
>   at 
> org.apache.asterix.om.typecomputer.base.AbstractResultTypeComputer.lambda$computeType$2(AbstractResultTypeComputer.java:39)
>   at 
> org.apache.asterix.om.typecomputer.base.AbstractResultTypeComputer$$Lambda$18/1226615280.checkArgTypes(Unknown
>  Source)
>   at 
> org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.resolveResultType(TypeComputeUtils.java:92)
>   at 
> org.apache.asterix.om.typecomputer.base.AbstractResultTypeComputer.computeType(AbstractResultTypeComputer.java:39)
>   at 
> org.apache.asterix.dataflow.data.common.AqlExpressionTypeComputer.getTypeForFunction(AqlExpressionTypeComputer.java:80)
>   at 
> org.apache.asterix.dataflow.data.common.AqlExpressionTypeComputer.getType(AqlExpressionTypeComputer.java:53)
>   at 
> org.apache.hyracks.algebricks.core.algebra.typing.AbstractTypeEnvironment.getType(AbstractTypeEnvironment.java:45)
>   at 
> org.apache.hyracks.algebricks.core.algebra.operators.logical.UnnestOperator.computeOutputTypeEnvironment(UnnestOperator.java:51)
>   at 
> org.apache.hyracks.algebricks.core.rewriter.base.AlgebricksOptimizationContext.computeAndSetTypeEnvironmentForOperator(AlgebricksOptimizationContext.java:298)
>   at 
> org.apache.hyracks.algebricks.rewriter.rules.InferTypesRule.rewritePost(InferTypesRule.java:42)
>   at 
> org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:126)
>   at 
> org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
>   at 
> org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
>   at 
> org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
>   at 
> org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
>   at 
> org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
>   at 
> org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:112)
>   at 
> org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
>   at 
> org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
>   at 
> org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
>   at 
> org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
>   at 
> org.apache.hyracks.algebricks.compiler.rewriter.rulecontrollers.SequentialOnceRuleController.rewriteWithRuleCollection(SequentialOnceRuleController.java:44)
>   at 
> org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.runOptimizationSets(HeuristicOptimizer.java:102)
>   at 
> 

[jira] [Commented] (ASTERIXDB-1571) Subquery in from clause throws NullPointerException

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419863#comment-15419863
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1571:


Another query that causes NPE with identical stack trace

{code}
select coll_count((select * 
from samptable1 s1)) as c1;
{code}

> Subquery in from clause throws NullPointerException
> ---
>
> Key: ASTERIXDB-1571
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1571
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Master branch with latest commit id: 
> bd3a535b171a5cc7486175
>Reporter: Vignesh Raghunathan
>Assignee: Yingyi Bu
>
> To reproduce the issue, run the following sqlpp statements
> {code}
> drop dataverse sampdb if exists;
> create dataverse sampdb;
> use sampdb;
> drop dataset samptable if exists;
> drop type samptabletype if exists;
> create type samptabletype as closed {
>   id: int8
> };
> create dataset samptable(samptabletype) primary key id;
> insert into samptable ({'id' : 0});
> insert into samptable ({'id' : 1});
> select *
> from
> (
> select * from samptable
> );
> {code}
> Result:
> {code}
> Aug 12, 2016 1:57:08 PM org.apache.asterix.api.http.servlet.APIServlet doPost
> SEVERE: null
> java.lang.NullPointerException
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:130)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.clause.Projection.accept(Projection.java:45)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:193)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.clause.SelectRegular.accept(SelectRegular.java:40)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:169)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.clause.SelectClause.accept(SelectClause.java:42)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:140)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.struct.SetOperationInput.accept(SetOperationInput.java:56)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:201)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.clause.SelectSetOperation.accept(SelectSetOperation.java:47)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:223)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.expression.SelectExpression.accept(SelectExpression.java:55)
>   at 
> org.apache.asterix.lang.sqlpp.util.SqlppFormatPrintUtil.toString(SqlppFormatPrintUtil.java:90)
>   at 
> org.apache.asterix.lang.sqlpp.util.SqlppFormatPrintUtil.toString(SqlppFormatPrintUtil.java:76)
>   at 
> org.apache.asterix.lang.sqlpp.util.ExpressionToVariableUtil.getGeneratedIdentifier(ExpressionToVariableUtil.java:48)
>   at 
> org.apache.asterix.lang.sqlpp.util.ExpressionToVariableUtil.getGeneratedVariable(ExpressionToVariableUtil.java:91)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.FromTerm(SQLPPParser.java:3767)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.FromClause(SQLPPParser.java:3674)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectBlock(SQLPPParser.java:3342)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectSetOperation(SQLPPParser.java:3255)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectExpression(SQLPPParser.java:3226)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.Query(SQLPPParser.java:2176)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SingleStatement(SQLPPParser.java:414)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.Statement(SQLPPParser.java:325)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.parse(SQLPPParser.java:260)
>   at 
> org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:119)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
>   at 

[jira] [Created] (ASTERIXDB-1577) Confusing error message when conditions in where clause reference fields in dataset using dataset's name instead of alias

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1577:
--

 Summary: Confusing error message when conditions in where clause 
reference fields in dataset using dataset's name instead of alias  
 Key: ASTERIXDB-1577
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1577
 Project: Apache AsterixDB
  Issue Type: Bug
 Environment: Master branch with latest commit id: 
bd3a535b171a5cc7486175
Reporter: Vignesh Raghunathan


To reproduce this issue, run the following sqlpp statements:

{code}
drop dataverse sampdb if exists;
create dataverse sampdb;
use sampdb;

drop dataset samptable if exists;
drop type samptabletype if exists;

create type samptabletype as closed {
  id: int8
};

create dataset samptable1(samptabletype) primary key id;

insert into samptable1 ({'id' : 0});
insert into samptable1 ({'id' : 1});

select id 
from samptable1 s2 
where samptable1.id = 1;
{code}

{code}
org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: 
Inappropriate use of function 'dataset'
at 
org.apache.asterix.runtime.evaluators.common.FunctionManagerImpl.lookupFunction(FunctionManagerImpl.java:46)
at 
org.apache.asterix.runtime.formats.NonTaggedDataFormat.resolveFunction(NonTaggedDataFormat.java:354)
at 
org.apache.asterix.jobgen.QueryLogicalExpressionJobGen.createScalarFunctionEvaluatorFactory(QueryLogicalExpressionJobGen.java:137)
at 
org.apache.asterix.jobgen.QueryLogicalExpressionJobGen.createEvaluatorFactory(QueryLogicalExpressionJobGen.java:108)
at 
org.apache.hyracks.algebricks.core.algebra.expressions.LogicalExpressionJobGenToExpressionRuntimeProviderAdapter.createEvaluatorFactory(LogicalExpressionJobGenToExpressionRuntimeProviderAdapter.java:41)
at 
org.apache.asterix.optimizer.rules.ConstantFoldingRule$ConstantFoldingVisitor.visitScalarFunctionCallExpression(ConstantFoldingRule.java:217)
at 
org.apache.asterix.optimizer.rules.ConstantFoldingRule$ConstantFoldingVisitor.visitScalarFunctionCallExpression(ConstantFoldingRule.java:151)
at 
org.apache.hyracks.algebricks.core.algebra.expressions.ScalarFunctionCallExpression.accept(ScalarFunctionCallExpression.java:55)
at 
org.apache.asterix.optimizer.rules.ConstantFoldingRule$ConstantFoldingVisitor.changeRec(ConstantFoldingRule.java:259)
at 
org.apache.asterix.optimizer.rules.ConstantFoldingRule$ConstantFoldingVisitor.visitScalarFunctionCallExpression(ConstantFoldingRule.java:183)
at 
org.apache.asterix.optimizer.rules.ConstantFoldingRule$ConstantFoldingVisitor.visitScalarFunctionCallExpression(ConstantFoldingRule.java:151)
at 
org.apache.hyracks.algebricks.core.algebra.expressions.ScalarFunctionCallExpression.accept(ScalarFunctionCallExpression.java:55)
at 
org.apache.asterix.optimizer.rules.ConstantFoldingRule$ConstantFoldingVisitor.changeRec(ConstantFoldingRule.java:259)
at 
org.apache.asterix.optimizer.rules.ConstantFoldingRule$ConstantFoldingVisitor.visitScalarFunctionCallExpression(ConstantFoldingRule.java:183)
at 
org.apache.asterix.optimizer.rules.ConstantFoldingRule$ConstantFoldingVisitor.visitScalarFunctionCallExpression(ConstantFoldingRule.java:151)
at 
org.apache.hyracks.algebricks.core.algebra.expressions.ScalarFunctionCallExpression.accept(ScalarFunctionCallExpression.java:55)
at 
org.apache.asterix.optimizer.rules.ConstantFoldingRule$ConstantFoldingVisitor.transform(ConstantFoldingRule.java:161)
at 
org.apache.hyracks.algebricks.core.algebra.operators.logical.SelectOperator.acceptExpressionTransform(SelectOperator.java:83)
at 
org.apache.asterix.optimizer.rules.ConstantFoldingRule.rewritePost(ConstantFoldingRule.java:148)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:126)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.compiler.rewriter.rulecontrollers.SequentialFixpointRuleController.rewriteWithRuleCollection(SequentialFixpointRuleController.java:53)
at 
org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.runOptimizationSets(HeuristicOptimizer.java:102)
at 
org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.optimize(HeuristicOptimizer.java:82)
at 
org.apache.hyracks.algebricks.compiler.api.HeuristicCompilerFactoryBuilder$1$1.optimize(HeuristicCompilerFactoryBuilder.java:90)
at 

[jira] [Commented] (ASTERIXDB-1562) NotImplemented Exception thrown when external delimited file is loaded using sql++

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419860#comment-15419860
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1562:


As discussed in the weekly meeting, If Date type isn't supported for loading 
data from local filesystem to a dataset, I can close this ticket. 

It would be helpful if the unsupported types are mentioned in the 
documentation. 

> NotImplemented Exception thrown when external delimited file is loaded using 
> sql++
> --
>
> Key: ASTERIXDB-1562
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1562
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Build 380b0a27
>Reporter: Vignesh Raghunathan
> Attachments: call_center.dat
>
>
> To reproduce the issue, create a type and table using sql++ as follows:
> {code}
> create type call_center_type as closed {
> cc_call_center_sk: int64  ,
> cc_call_center_id: string ,
> cc_rec_start_date: date?,
> cc_rec_end_date:   date?,
> cc_closed_date_sk: int64?   ,
> cc_open_date_sk:   int64?   ,
> cc_name:   string?,
> cc_class:  string?,
> cc_employees:  int64?   ,
> cc_sq_ft:  int64?   ,
> cc_hours:  string?  ,
> cc_manager:string?,
> cc_mkt_id: int64?   ,
> cc_mkt_class:  string?  ,
> cc_mkt_desc:   string?,
> cc_market_manager: string?,
> cc_division:   int64?   ,
> cc_division_name:  string?,
> cc_company:int64?   ,
> cc_company_name:   string?  ,
> cc_street_number:  int64? ,
> cc_street_name:string?,
> cc_street_type:string?  ,
> cc_suite_number:   string?  ,
> cc_city:   string?,
> cc_county: string?,
> cc_state:  string?  ,
> cc_zip:string?  ,
> cc_country:string?,
> cc_gmt_offset: double?,
> cc_tax_percentage: double?
> }
> create table call_center (call_center_type)
> primary key cc_call_center_sk;
> {code}
> Then load the file call_center.dat
> {code}
> load  table call_center using localfs ((`path`=`hostname:// call_center.dat>`),(`format`=`delimited-text`),(`delimiter`=`|`));
> {code}
> The following exceptions are thrown:
> {code}
> org.apache.hyracks.api.exceptions.HyracksException: Job failed on account of:
> HYR0002: org.apache.hyracks.api.exceptions.HyracksDataException: No value 
> parser factory for fields of type DATE
>   at 
> org.apache.hyracks.control.cc.job.JobRun.waitForCompletion(JobRun.java:212)
>   at 
> org.apache.hyracks.control.cc.work.WaitForJobCompletionWork$1.run(WaitForJobCompletionWork.java:48)
>   at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>   at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>   at java.lang.Thread.run(Thread.java:745)
> Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: HYR0002: 
> org.apache.hyracks.api.exceptions.HyracksDataException: No value parser 
> factory for fields of type DATE
>   at 
> org.apache.hyracks.control.common.utils.ExceptionUtils.setNodeIds(ExceptionUtils.java:62)
>   at org.apache.hyracks.control.nc.Task.run(Task.java:319)
>   ... 3 more
> Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: 
> org.apache.hyracks.api.exceptions.HyracksDataException: No value parser 
> factory for fields of type DATE
>   at 
> org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.runInParallel(SuperActivityOperatorNodePushable.java:218)
>   at 
> org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.initialize(SuperActivityOperatorNodePushable.java:83)
>   at org.apache.hyracks.control.nc.Task.run(Task.java:263)
> 

[jira] [Commented] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419859#comment-15419859
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1546:


In https://asterixdb.apache.org/dev-setup.html, step 4 under Eclipse-IDE setup 
already addresses this issue. 

> Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
> 
>
> Key: ASTERIXDB-1546
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1546
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Eclipse IDE
> Version: Neon Release (4.6.0)
> Build id: 20160613-1800
>Reporter: Vignesh Raghunathan
>
> After launching an AsterixDB instance using 
> AsterixHyracksIntegrationUtil.java, the following exceptions are thrown after 
> a query like abs(-1) is executed.
> 2016-07-25 16:03:00,412 WARN  [qtp1833789138-36] util.log 
> (JCLLoggerAdapter.java:warn(437)) - Error for /
> java.lang.ExceptionInInitializerError
>   at 
> org.apache.asterix.translator.LangExpressionToPlanTranslator.(LangExpressionToPlanTranslator.java:177)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslator.(AqlExpressionToPlanTranslator.java:72)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslatorFactory.createExpressionToPlanTranslator(AqlExpressionToPlanTranslatorFactory.java:31)
>   at 
> org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:208)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1938)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.handleQuery(QueryTranslator.java:2534)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:365)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:258)
>   at 
> org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:130)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
>   at 
> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:546)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:483)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:228)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:956)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:411)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:188)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:891)
>   at 
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
>   at 
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
>   at org.eclipse.jetty.server.Server.handle(Server.java:353)
>   at 
> org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:598)
>   at 
> org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1076)
>   at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805)
>   at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218)
>   at 
> org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:427)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:510)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)
>   at 
> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:450)
>   at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.IllegalStateException: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at 
> org.apache.asterix.translator.util.FunctionCollection.getGeneratedFunctionDescriptorFactory(FunctionCollection.java:643)
>   at 
> org.apache.asterix.translator.util.FunctionCollection.(FunctionCollection.java:618)
>   ... 31 more
> Caused by: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
>   at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
>   at java.security.AccessController.doPrivileged(Native Method)
>   at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
>   at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>   at 

[jira] [Created] (ASTERIXDB-1576) Select * with more than two tables in from clause without aliases throws AlgebricksException

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1576:
--

 Summary: Select * with more than two tables in from clause without 
aliases throws AlgebricksException
 Key: ASTERIXDB-1576
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1576
 Project: Apache AsterixDB
  Issue Type: Bug
 Environment: Master branch with latest commit id: 
bd3a535b171a5cc7486175
Reporter: Vignesh Raghunathan


To reproduce the issue, execute the following sqlpp statements:

{code}
drop dataverse sampdb if exists;
create dataverse sampdb;
use sampdb;

drop dataset samptable if exists;
drop type samptabletype if exists;

create type samptabletype as closed {
  id: int8
};

create dataset samptable1(samptabletype) primary key id;

insert into samptable1 ({'id' : 0});
insert into samptable1 ({'id' : 1});

select * 
from samptable1, samptable1, samptable1;
{code}

Result:

{code}
org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: The input 
type for input argument 0(ARecord) is not expected.
at 
org.apache.asterix.om.typecomputer.impl.CollectionMemberResultType.checkArgType(CollectionMemberResultType.java:40)
at 
org.apache.asterix.om.typecomputer.base.AbstractResultTypeComputer.lambda$computeType$2(AbstractResultTypeComputer.java:39)
at 
org.apache.asterix.om.typecomputer.base.AbstractResultTypeComputer$$Lambda$23/2116803859.checkArgTypes(Unknown
 Source)
at 
org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.resolveResultType(TypeComputeUtils.java:92)
at 
org.apache.asterix.om.typecomputer.base.AbstractResultTypeComputer.computeType(AbstractResultTypeComputer.java:39)
at 
org.apache.asterix.dataflow.data.common.AqlExpressionTypeComputer.getTypeForFunction(AqlExpressionTypeComputer.java:80)
at 
org.apache.asterix.dataflow.data.common.AqlExpressionTypeComputer.getType(AqlExpressionTypeComputer.java:53)
at 
org.apache.hyracks.algebricks.core.algebra.typing.AbstractTypeEnvironment.getType(AbstractTypeEnvironment.java:45)
at 
org.apache.hyracks.algebricks.core.algebra.operators.logical.UnnestOperator.computeOutputTypeEnvironment(UnnestOperator.java:51)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AlgebricksOptimizationContext.computeAndSetTypeEnvironmentForOperator(AlgebricksOptimizationContext.java:298)
at 
org.apache.hyracks.algebricks.rewriter.rules.InferTypesRule.rewritePost(InferTypesRule.java:42)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:126)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.compiler.rewriter.rulecontrollers.SequentialOnceRuleController.rewriteWithRuleCollection(SequentialOnceRuleController.java:44)
at 
org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.runOptimizationSets(HeuristicOptimizer.java:102)
at 
org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.optimize(HeuristicOptimizer.java:82)
at 
org.apache.hyracks.algebricks.compiler.api.HeuristicCompilerFactoryBuilder$1$1.optimize(HeuristicCompilerFactoryBuilder.java:90)
at 
org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:268)
at 
org.apache.asterix.aql.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1938)
at 
org.apache.asterix.aql.translator.QueryTranslator.handleQuery(QueryTranslator.java:2533)
at 
org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:365)
at 
org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:258)
at 
org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at 
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:845)
at 
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)
at 
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224)
at 
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)
at 
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
at 

[jira] [Commented] (ASTERIXDB-1571) Subquery in from clause throws NullPointerException

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419840#comment-15419840
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1571:


Thanks for pointing that out. I didn't realize select * returned nested tuples.

> Subquery in from clause throws NullPointerException
> ---
>
> Key: ASTERIXDB-1571
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1571
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Master branch with latest commit id: 
> bd3a535b171a5cc7486175
>Reporter: Vignesh Raghunathan
>Assignee: Yingyi Bu
>
> To reproduce the issue, run the following sqlpp statements
> {code}
> drop dataverse sampdb if exists;
> create dataverse sampdb;
> use sampdb;
> drop dataset samptable if exists;
> drop type samptabletype if exists;
> create type samptabletype as closed {
>   id: int8
> };
> create dataset samptable(samptabletype) primary key id;
> insert into samptable ({'id' : 0});
> insert into samptable ({'id' : 1});
> select *
> from
> (
> select * from samptable
> );
> {code}
> Result:
> {code}
> Aug 12, 2016 1:57:08 PM org.apache.asterix.api.http.servlet.APIServlet doPost
> SEVERE: null
> java.lang.NullPointerException
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:130)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.clause.Projection.accept(Projection.java:45)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:193)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.clause.SelectRegular.accept(SelectRegular.java:40)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:169)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.clause.SelectClause.accept(SelectClause.java:42)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:140)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.struct.SetOperationInput.accept(SetOperationInput.java:56)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:201)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.clause.SelectSetOperation.accept(SelectSetOperation.java:47)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:223)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.expression.SelectExpression.accept(SelectExpression.java:55)
>   at 
> org.apache.asterix.lang.sqlpp.util.SqlppFormatPrintUtil.toString(SqlppFormatPrintUtil.java:90)
>   at 
> org.apache.asterix.lang.sqlpp.util.SqlppFormatPrintUtil.toString(SqlppFormatPrintUtil.java:76)
>   at 
> org.apache.asterix.lang.sqlpp.util.ExpressionToVariableUtil.getGeneratedIdentifier(ExpressionToVariableUtil.java:48)
>   at 
> org.apache.asterix.lang.sqlpp.util.ExpressionToVariableUtil.getGeneratedVariable(ExpressionToVariableUtil.java:91)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.FromTerm(SQLPPParser.java:3767)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.FromClause(SQLPPParser.java:3674)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectBlock(SQLPPParser.java:3342)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectSetOperation(SQLPPParser.java:3255)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectExpression(SQLPPParser.java:3226)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.Query(SQLPPParser.java:2176)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SingleStatement(SQLPPParser.java:414)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.Statement(SQLPPParser.java:325)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.parse(SQLPPParser.java:260)
>   at 
> org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:119)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
>   at 
> 

[jira] [Commented] (ASTERIXDB-1478) using localfs goes wrong

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419185#comment-15419185
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1478:


I was facing a similar issue earlier and I did a cursory analysis of the code 
dealing with reading data from the local file system.

My input file had the characters CÔTE D'IVOIRE. When the character Ô is 
encountered, the decoder.decode() method returns a CoderResult object 
indicating a malformed input. However, this CoderResult object is ignored. This 
results in charbuffer's position staying at 0 which results in an infinite 
loop. 

I created a temporary fix by making the decoder ignore malformed input.

I haven't looked at the code thoroughly but I could see that 
AsterixInputStreamReader uses AsterixInputStream which is a byte stream. 
Neither the read method in AsterixInputStream nor AsterixInputStreamReader have 
checks for partial reads of bytes corresponding to utf8 characters between 
calls to the read method.

> using localfs goes wrong
> 
>
> Key: ASTERIXDB-1478
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1478
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: Error Reporting
> Environment: AsterixDB 0.8.9(pulled from github today)
> Ubuntu 14.0
> Java -version 1.8.0_79
> Computer has 1 ssd and 1 hhd
>Reporter: yipzifai
>Assignee: Wenhai
>  Labels: features
> Attachments: cc.log, cpu.jpg, execute.log, my_asterix_nc1.log, 
> my_asterix_nc2.log
>
>
> I load data file using localfs but AsterixDB keeps running for a long long 
> time.(ps:CPU utilization ~= 100%) I have been waiting over 8 hours 
> yesterday.Then i found that the storage folder in workingdir didn't add any 
> files.
> Exectly, I try to use feeding or AQL "Insert", but it still goes wrong.
> AQL:
> use dataverse test;
> drop dataset relationship_B if exists;
> drop type relationshipB if exists;
> create type relationshipB as closed{
> pkId:int64,
> who_id:int64,
> who_name:string,
> id:int64,
> name:string,
> code:string,
> shortname:string,
> brief:string,
> validateDate:date?,
> gfType:string,
> shijizengjianchi:string,
> chiyoushuliang:double,
> chigubianhua:string,
> zhanbi:double,
> konggugongsiID:int64?,
> konggugongsiName:string?,
> rType:string,
> source:string,
> method:string
> };
> create dataset relationship_B(relationshipB) primary key pkId;
> use dataverse test;
> load dataset relationship_B
> using localfs
> (("path"="127.0.0.1:///home/to/adbSrc/ddl/relationshipB.adm"),("format"="adm"));
> About data files:
> one file is big object insertion(each record has over 30,000 characters); 
> each record of another file has 100~200 characters.
> {code}
> local.xml
> 
> 
> /usr/local/jdk1.8.0_91/jre
> 
> /home/to/adbSrc/asterix-mgmt/clusters/local/working_dir/logs
> 
> /home/to/adbSrc/asterix-mgmt/clusters/local/working_dir/txnLogs
> storage
> 
> /home/to/adbSrc/asterix-mgmt/clusters/local/working_dir
> true
> 
>   
> /home/to/adbSrc/asterix-mgmt/clusters/local/working_dir/nc/p1,/home/to/adbSrc/asterix-mgmt/clusters/local/working_dir/nc/p2
> 
> master
> 127.0.0.1
> 127.0.0.1
> 1098
> 1099
> 
> 8900
> 
> 
> nc1
> 127.0.0.1
> 
> /home/to/adbSrc/asterix-mgmt/clusters/local/working_dir/nc1/txnLogs
>  
> 8901
> 
> 
> nc2
> 127.0.0.1
> 
> /home/to/adbSrc/asterix-mgmt/clusters/local/working_dir/nc2/txnLogs
>   
> 8902
> 
> 1
> 5
> 0
> 5
> 10
> 8640
> 6
> 
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (ASTERIXDB-1571) Subquery in from clause throws NullPointerException

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15419132#comment-15419132
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1571:


Could you please try the following query?

{code}
drop dataverse sampdb if exists;
create dataverse sampdb;
use sampdb;

drop dataset samptable if exists;
drop type samptabletype if exists;

create type samptabletype as closed {
  id: int8
};

create dataset samptable(samptabletype) primary key id;

insert into samptable ({'id' : 0});
insert into samptable ({'id' : 1});

with samptable1 as 
(
select * from samptable
)

select *
from
(
select * from 
samptable1 s1 
left outer join 
samptable1 s2
on s1.id = s2.id
) t ;
{code}

I tried to simplify my original query. Since the previous query was throwing a 
NPE, I assumed they were due to same reason without looking at the stack trace.

> Subquery in from clause throws NullPointerException
> ---
>
> Key: ASTERIXDB-1571
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1571
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Master branch with latest commit id: 
> bd3a535b171a5cc7486175
>Reporter: Vignesh Raghunathan
>Assignee: Yingyi Bu
>
> To reproduce the issue, run the following sqlpp statements
> {code}
> drop dataverse sampdb if exists;
> create dataverse sampdb;
> use sampdb;
> drop dataset samptable if exists;
> drop type samptabletype if exists;
> create type samptabletype as closed {
>   id: int8
> };
> create dataset samptable(samptabletype) primary key id;
> insert into samptable ({'id' : 0});
> insert into samptable ({'id' : 1});
> select *
> from
> (
> select * from samptable
> );
> {code}
> Result:
> {code}
> Aug 12, 2016 1:57:08 PM org.apache.asterix.api.http.servlet.APIServlet doPost
> SEVERE: null
> java.lang.NullPointerException
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:130)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.clause.Projection.accept(Projection.java:45)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:193)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.clause.SelectRegular.accept(SelectRegular.java:40)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:169)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.clause.SelectClause.accept(SelectClause.java:42)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:140)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.struct.SetOperationInput.accept(SetOperationInput.java:56)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:201)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.clause.SelectSetOperation.accept(SelectSetOperation.java:47)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:223)
>   at 
> org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
>   at 
> org.apache.asterix.lang.sqlpp.expression.SelectExpression.accept(SelectExpression.java:55)
>   at 
> org.apache.asterix.lang.sqlpp.util.SqlppFormatPrintUtil.toString(SqlppFormatPrintUtil.java:90)
>   at 
> org.apache.asterix.lang.sqlpp.util.SqlppFormatPrintUtil.toString(SqlppFormatPrintUtil.java:76)
>   at 
> org.apache.asterix.lang.sqlpp.util.ExpressionToVariableUtil.getGeneratedIdentifier(ExpressionToVariableUtil.java:48)
>   at 
> org.apache.asterix.lang.sqlpp.util.ExpressionToVariableUtil.getGeneratedVariable(ExpressionToVariableUtil.java:91)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.FromTerm(SQLPPParser.java:3767)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.FromClause(SQLPPParser.java:3674)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectBlock(SQLPPParser.java:3342)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectSetOperation(SQLPPParser.java:3255)
>   at 
> org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectExpression(SQLPPParser.java:3226)
>   at 
> 

[jira] [Created] (ASTERIXDB-1574) Result of subquery in where clause could not be cast to a scalar value

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1574:
--

 Summary: Result of subquery in where clause could not be cast to a 
scalar value
 Key: ASTERIXDB-1574
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1574
 Project: Apache AsterixDB
  Issue Type: Bug
 Environment: Master branch with latest commit id: 
bd3a535b171a5cc7486175
Reporter: Vignesh Raghunathan


To reproduce the issue, run the following sqlpp statements:

{code}
drop dataverse sampdb if exists;
create dataverse sampdb;
use sampdb;

drop dataset samptable if exists;
drop type samptabletype if exists;

create type samptabletype as closed {
  id: int64
};

create dataset samptable(samptabletype) primary key id;

insert into samptable ({'id' : 1});
insert into samptable ({'id' : 2});
insert into samptable ({'id' : 3});
insert into samptable ({'id' : 4});
insert into samptable ({'id' : 5});

select *
from samptable 
where id > (select value avg(id) from samptable)[0];
{code}

Result:

{code}
org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: The input 
type for input argument 0(ARecord) is not expected.
at 
org.apache.asterix.om.typecomputer.impl.CollectionMemberResultType.checkArgType(CollectionMemberResultType.java:40)
at 
org.apache.asterix.om.typecomputer.base.AbstractResultTypeComputer.lambda$computeType$2(AbstractResultTypeComputer.java:39)
at 
org.apache.asterix.om.typecomputer.base.AbstractResultTypeComputer$$Lambda$18/1226615280.checkArgTypes(Unknown
 Source)
at 
org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.resolveResultType(TypeComputeUtils.java:92)
at 
org.apache.asterix.om.typecomputer.base.AbstractResultTypeComputer.computeType(AbstractResultTypeComputer.java:39)
at 
org.apache.asterix.dataflow.data.common.AqlExpressionTypeComputer.getTypeForFunction(AqlExpressionTypeComputer.java:80)
at 
org.apache.asterix.dataflow.data.common.AqlExpressionTypeComputer.getType(AqlExpressionTypeComputer.java:53)
at 
org.apache.hyracks.algebricks.core.algebra.typing.AbstractTypeEnvironment.getType(AbstractTypeEnvironment.java:45)
at 
org.apache.hyracks.algebricks.core.algebra.operators.logical.UnnestOperator.computeOutputTypeEnvironment(UnnestOperator.java:51)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AlgebricksOptimizationContext.computeAndSetTypeEnvironmentForOperator(AlgebricksOptimizationContext.java:298)
at 
org.apache.hyracks.algebricks.rewriter.rules.InferTypesRule.rewritePost(InferTypesRule.java:42)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:126)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:112)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:100)
at 
org.apache.hyracks.algebricks.compiler.rewriter.rulecontrollers.SequentialOnceRuleController.rewriteWithRuleCollection(SequentialOnceRuleController.java:44)
at 
org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.runOptimizationSets(HeuristicOptimizer.java:102)
at 
org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.optimize(HeuristicOptimizer.java:82)
at 
org.apache.hyracks.algebricks.compiler.api.HeuristicCompilerFactoryBuilder$1$1.optimize(HeuristicCompilerFactoryBuilder.java:90)
at 
org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:268)
at 
org.apache.asterix.aql.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1938)
at 

[jira] [Created] (ASTERIXDB-1571) Subquery in from clause throws NullPointerException

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1571:
--

 Summary: Subquery in from clause throws NullPointerException
 Key: ASTERIXDB-1571
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1571
 Project: Apache AsterixDB
  Issue Type: Bug
 Environment: Master branch with latest commit id: 
bd3a535b171a5cc7486175
Reporter: Vignesh Raghunathan


To reproduce the issue, run the following sqlpp statements

{code}
drop dataset samptable if exists;
drop type samptabletype if exists;

create type samptabletype as closed {
  id: int8
};

create dataset samptable(samptabletype) primary key id;

insert into samptable ({'id' : 0});
insert into samptable ({'id' : 1});

select *
from
(
select * from jointable
)
{code}

Result:

{code}
Aug 12, 2016 1:57:08 PM org.apache.asterix.api.http.servlet.APIServlet doPost
SEVERE: null
java.lang.NullPointerException
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:130)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.clause.Projection.accept(Projection.java:45)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:193)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.clause.SelectRegular.accept(SelectRegular.java:40)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:169)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.clause.SelectClause.accept(SelectClause.java:42)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:140)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.struct.SetOperationInput.accept(SetOperationInput.java:56)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:201)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.clause.SelectSetOperation.accept(SelectSetOperation.java:47)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:223)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.expression.SelectExpression.accept(SelectExpression.java:55)
at 
org.apache.asterix.lang.sqlpp.util.SqlppFormatPrintUtil.toString(SqlppFormatPrintUtil.java:90)
at 
org.apache.asterix.lang.sqlpp.util.SqlppFormatPrintUtil.toString(SqlppFormatPrintUtil.java:76)
at 
org.apache.asterix.lang.sqlpp.util.ExpressionToVariableUtil.getGeneratedIdentifier(ExpressionToVariableUtil.java:48)
at 
org.apache.asterix.lang.sqlpp.util.ExpressionToVariableUtil.getGeneratedVariable(ExpressionToVariableUtil.java:91)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.FromTerm(SQLPPParser.java:3767)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.FromClause(SQLPPParser.java:3674)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectBlock(SQLPPParser.java:3342)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectSetOperation(SQLPPParser.java:3255)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectExpression(SQLPPParser.java:3226)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.Query(SQLPPParser.java:2176)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SingleStatement(SQLPPParser.java:414)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.Statement(SQLPPParser.java:325)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.parse(SQLPPParser.java:260)
at 
org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at 
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:845)
at 
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)
at 
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224)
at 
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)
at 
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
at 

[jira] [Updated] (ASTERIXDB-1571) Subquery in from clause throws NullPointerException

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan updated ASTERIXDB-1571:
---
Description: 
To reproduce the issue, run the following sqlpp statements

{code}
drop dataset samptable if exists;
drop type samptabletype if exists;

create type samptabletype as closed {
  id: int8
};

create dataset samptable(samptabletype) primary key id;

insert into samptable ({'id' : 0});
insert into samptable ({'id' : 1});

select *
from
(
select * from samptable
)
{code}

Result:

{code}
Aug 12, 2016 1:57:08 PM org.apache.asterix.api.http.servlet.APIServlet doPost
SEVERE: null
java.lang.NullPointerException
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:130)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.clause.Projection.accept(Projection.java:45)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:193)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.clause.SelectRegular.accept(SelectRegular.java:40)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:169)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.clause.SelectClause.accept(SelectClause.java:42)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:140)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.struct.SetOperationInput.accept(SetOperationInput.java:56)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:201)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.clause.SelectSetOperation.accept(SelectSetOperation.java:47)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:223)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.expression.SelectExpression.accept(SelectExpression.java:55)
at 
org.apache.asterix.lang.sqlpp.util.SqlppFormatPrintUtil.toString(SqlppFormatPrintUtil.java:90)
at 
org.apache.asterix.lang.sqlpp.util.SqlppFormatPrintUtil.toString(SqlppFormatPrintUtil.java:76)
at 
org.apache.asterix.lang.sqlpp.util.ExpressionToVariableUtil.getGeneratedIdentifier(ExpressionToVariableUtil.java:48)
at 
org.apache.asterix.lang.sqlpp.util.ExpressionToVariableUtil.getGeneratedVariable(ExpressionToVariableUtil.java:91)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.FromTerm(SQLPPParser.java:3767)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.FromClause(SQLPPParser.java:3674)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectBlock(SQLPPParser.java:3342)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectSetOperation(SQLPPParser.java:3255)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectExpression(SQLPPParser.java:3226)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.Query(SQLPPParser.java:2176)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SingleStatement(SQLPPParser.java:414)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.Statement(SQLPPParser.java:325)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.parse(SQLPPParser.java:260)
at 
org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at 
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:845)
at 
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)
at 
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224)
at 
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)
at 
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
at 
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at 
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
at 
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at 

[jira] [Updated] (ASTERIXDB-1571) Subquery in from clause throws NullPointerException

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan updated ASTERIXDB-1571:
---
Description: 
To reproduce the issue, run the following sqlpp statements

{code}
drop dataverse sampdb if exists;
create dataverse sampdb;
use sampdb;

drop dataset samptable if exists;
drop type samptabletype if exists;

create type samptabletype as closed {
  id: int8
};

create dataset samptable(samptabletype) primary key id;

insert into samptable ({'id' : 0});
insert into samptable ({'id' : 1});

select *
from
(
select * from samptable
)
{code}

Result:

{{
Aug 12, 2016 1:57:08 PM org.apache.asterix.api.http.servlet.APIServlet doPost
SEVERE: null
java.lang.NullPointerException
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:130)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.clause.Projection.accept(Projection.java:45)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:193)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.clause.SelectRegular.accept(SelectRegular.java:40)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:169)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.clause.SelectClause.accept(SelectClause.java:42)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:140)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.struct.SetOperationInput.accept(SetOperationInput.java:56)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:201)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.clause.SelectSetOperation.accept(SelectSetOperation.java:47)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:223)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.expression.SelectExpression.accept(SelectExpression.java:55)
at 
org.apache.asterix.lang.sqlpp.util.SqlppFormatPrintUtil.toString(SqlppFormatPrintUtil.java:90)
at 
org.apache.asterix.lang.sqlpp.util.SqlppFormatPrintUtil.toString(SqlppFormatPrintUtil.java:76)
at 
org.apache.asterix.lang.sqlpp.util.ExpressionToVariableUtil.getGeneratedIdentifier(ExpressionToVariableUtil.java:48)
at 
org.apache.asterix.lang.sqlpp.util.ExpressionToVariableUtil.getGeneratedVariable(ExpressionToVariableUtil.java:91)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.FromTerm(SQLPPParser.java:3767)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.FromClause(SQLPPParser.java:3674)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectBlock(SQLPPParser.java:3342)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectSetOperation(SQLPPParser.java:3255)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectExpression(SQLPPParser.java:3226)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.Query(SQLPPParser.java:2176)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SingleStatement(SQLPPParser.java:414)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.Statement(SQLPPParser.java:325)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.parse(SQLPPParser.java:260)
at 
org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at 
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:845)
at 
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)
at 
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224)
at 
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)
at 
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
at 
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at 
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
at 

[jira] [Updated] (ASTERIXDB-1571) Subquery in from clause throws NullPointerException

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan updated ASTERIXDB-1571:
---
Description: 
To reproduce the issue, run the following sqlpp statements

{code}
drop dataverse sampdb if exists;
create dataverse sampdb;
use sampdb;

drop dataset samptable if exists;
drop type samptabletype if exists;

create type samptabletype as closed {
  id: int8
};

create dataset samptable(samptabletype) primary key id;

insert into samptable ({'id' : 0});
insert into samptable ({'id' : 1});

select *
from
(
select * from samptable
)
{code}

Result:

{code}
Aug 12, 2016 1:57:08 PM org.apache.asterix.api.http.servlet.APIServlet doPost
SEVERE: null
java.lang.NullPointerException
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:130)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.clause.Projection.accept(Projection.java:45)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:193)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.clause.SelectRegular.accept(SelectRegular.java:40)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:169)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.clause.SelectClause.accept(SelectClause.java:42)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:140)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.struct.SetOperationInput.accept(SetOperationInput.java:56)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:201)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.clause.SelectSetOperation.accept(SelectSetOperation.java:47)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:223)
at 
org.apache.asterix.lang.sqlpp.visitor.SqlppFormatPrintVisitor.visit(SqlppFormatPrintVisitor.java:1)
at 
org.apache.asterix.lang.sqlpp.expression.SelectExpression.accept(SelectExpression.java:55)
at 
org.apache.asterix.lang.sqlpp.util.SqlppFormatPrintUtil.toString(SqlppFormatPrintUtil.java:90)
at 
org.apache.asterix.lang.sqlpp.util.SqlppFormatPrintUtil.toString(SqlppFormatPrintUtil.java:76)
at 
org.apache.asterix.lang.sqlpp.util.ExpressionToVariableUtil.getGeneratedIdentifier(ExpressionToVariableUtil.java:48)
at 
org.apache.asterix.lang.sqlpp.util.ExpressionToVariableUtil.getGeneratedVariable(ExpressionToVariableUtil.java:91)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.FromTerm(SQLPPParser.java:3767)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.FromClause(SQLPPParser.java:3674)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectBlock(SQLPPParser.java:3342)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectSetOperation(SQLPPParser.java:3255)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SelectExpression(SQLPPParser.java:3226)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.Query(SQLPPParser.java:2176)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.SingleStatement(SQLPPParser.java:414)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.Statement(SQLPPParser.java:325)
at 
org.apache.asterix.lang.sqlpp.parser.SQLPPParser.parse(SQLPPParser.java:260)
at 
org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at 
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:845)
at 
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)
at 
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224)
at 
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)
at 
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
at 
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at 
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
at 

[jira] [Commented] (ASTERIXDB-1562) NotImplemented Exception thrown when external delimited file is loaded using sql++

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15404956#comment-15404956
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1562:


I inserted  into 
valueParserFactoryMap as a temporary fix.

> NotImplemented Exception thrown when external delimited file is loaded using 
> sql++
> --
>
> Key: ASTERIXDB-1562
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1562
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Build 380b0a27
>Reporter: Vignesh Raghunathan
> Attachments: call_center.dat
>
>
> To reproduce the issue, create a type and table using sql++ as follows:
> {code}
> create type call_center_type as closed {
> cc_call_center_sk: int64  ,
> cc_call_center_id: string ,
> cc_rec_start_date: date?,
> cc_rec_end_date:   date?,
> cc_closed_date_sk: int64?   ,
> cc_open_date_sk:   int64?   ,
> cc_name:   string?,
> cc_class:  string?,
> cc_employees:  int64?   ,
> cc_sq_ft:  int64?   ,
> cc_hours:  string?  ,
> cc_manager:string?,
> cc_mkt_id: int64?   ,
> cc_mkt_class:  string?  ,
> cc_mkt_desc:   string?,
> cc_market_manager: string?,
> cc_division:   int64?   ,
> cc_division_name:  string?,
> cc_company:int64?   ,
> cc_company_name:   string?  ,
> cc_street_number:  int64? ,
> cc_street_name:string?,
> cc_street_type:string?  ,
> cc_suite_number:   string?  ,
> cc_city:   string?,
> cc_county: string?,
> cc_state:  string?  ,
> cc_zip:string?  ,
> cc_country:string?,
> cc_gmt_offset: double?,
> cc_tax_percentage: double?
> }
> create table call_center (call_center_type)
> primary key cc_call_center_sk;
> {code}
> Then load the file call_center.dat
> {code}
> load  table call_center using localfs ((`path`=`hostname:// call_center.dat>`),(`format`=`delimited-text`),(`delimiter`=`|`));
> {code}
> The following exceptions are thrown:
> {code}
> org.apache.hyracks.api.exceptions.HyracksException: Job failed on account of:
> HYR0002: org.apache.hyracks.api.exceptions.HyracksDataException: No value 
> parser factory for fields of type DATE
>   at 
> org.apache.hyracks.control.cc.job.JobRun.waitForCompletion(JobRun.java:212)
>   at 
> org.apache.hyracks.control.cc.work.WaitForJobCompletionWork$1.run(WaitForJobCompletionWork.java:48)
>   at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>   at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>   at java.lang.Thread.run(Thread.java:745)
> Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: HYR0002: 
> org.apache.hyracks.api.exceptions.HyracksDataException: No value parser 
> factory for fields of type DATE
>   at 
> org.apache.hyracks.control.common.utils.ExceptionUtils.setNodeIds(ExceptionUtils.java:62)
>   at org.apache.hyracks.control.nc.Task.run(Task.java:319)
>   ... 3 more
> Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: 
> org.apache.hyracks.api.exceptions.HyracksDataException: No value parser 
> factory for fields of type DATE
>   at 
> org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.runInParallel(SuperActivityOperatorNodePushable.java:218)
>   at 
> org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.initialize(SuperActivityOperatorNodePushable.java:83)
>   at org.apache.hyracks.control.nc.Task.run(Task.java:263)
>   ... 3 more
> Caused by: java.util.concurrent.ExecutionException: 
> 

[jira] [Updated] (ASTERIXDB-1562) NotImplemented Exception thrown when external delimited file is loaded using sql++

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan updated ASTERIXDB-1562:
---
Description: 
To reproduce the issue, create a type and table using sql++ as follows:

{code}
create type call_center_type as closed {
cc_call_center_sk: int64,
cc_call_center_id: string   ,
cc_rec_start_date: date?,
cc_rec_end_date:   date?,
cc_closed_date_sk: int64?   ,
cc_open_date_sk:   int64?   ,
cc_name:   string?  ,
cc_class:  string?  ,
cc_employees:  int64?   ,
cc_sq_ft:  int64?   ,
cc_hours:  string?  ,
cc_manager:string?  ,
cc_mkt_id: int64?   ,
cc_mkt_class:  string?  ,
cc_mkt_desc:   string?  ,
cc_market_manager: string?  ,
cc_division:   int64?   ,
cc_division_name:  string?  ,
cc_company:int64?   ,
cc_company_name:   string?  ,
cc_street_number:  int64?   ,
cc_street_name:string?  ,
cc_street_type:string?  ,
cc_suite_number:   string?  ,
cc_city:   string?  ,
cc_county: string?  ,
cc_state:  string?  ,
cc_zip:string?  ,
cc_country:string?  ,
cc_gmt_offset: double?  ,
cc_tax_percentage: double?  
}

create table call_center (call_center_type)
primary key cc_call_center_sk;
{code}

Then load the file call_center.dat

{code}
load  table call_center using localfs ((`path`=`hostname://`),(`format`=`delimited-text`),(`delimiter`=`|`));
{code}

The following exceptions are thrown:

{code}
org.apache.hyracks.api.exceptions.HyracksException: Job failed on account of:
HYR0002: org.apache.hyracks.api.exceptions.HyracksDataException: No value 
parser factory for fields of type DATE

at 
org.apache.hyracks.control.cc.job.JobRun.waitForCompletion(JobRun.java:212)
at 
org.apache.hyracks.control.cc.work.WaitForJobCompletionWork$1.run(WaitForJobCompletionWork.java:48)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: HYR0002: 
org.apache.hyracks.api.exceptions.HyracksDataException: No value parser factory 
for fields of type DATE
at 
org.apache.hyracks.control.common.utils.ExceptionUtils.setNodeIds(ExceptionUtils.java:62)
at org.apache.hyracks.control.nc.Task.run(Task.java:319)
... 3 more
Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: 
org.apache.hyracks.api.exceptions.HyracksDataException: No value parser factory 
for fields of type DATE
at 
org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.runInParallel(SuperActivityOperatorNodePushable.java:218)
at 
org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.initialize(SuperActivityOperatorNodePushable.java:83)
at org.apache.hyracks.control.nc.Task.run(Task.java:263)
... 3 more
Caused by: java.util.concurrent.ExecutionException: 
org.apache.hyracks.api.exceptions.HyracksDataException: No value parser factory 
for fields of type DATE
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:192)
at 
org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.runInParallel(SuperActivityOperatorNodePushable.java:212)
... 5 more
Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: No value 
parser factory for fields of type DATE
at 
org.apache.asterix.external.operators.ExternalDataScanOperatorDescriptor$1.initialize(ExternalDataScanOperatorDescriptor.java:65)
at 

[jira] [Updated] (ASTERIXDB-1562) NotImplemented Exception thrown when external delimited file is loaded using sql++

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan updated ASTERIXDB-1562:
---
Description: 
To reproduce the issue, create a type and table using sql++ as follows:

{code}
create type call_center_type as closed {
cc_call_center_sk: int64,
cc_call_center_id: string   ,
cc_rec_start_date: date?,
cc_rec_end_date:   date?,
cc_closed_date_sk: int64?   ,
cc_open_date_sk:   int64?   ,
cc_name:   string?  ,
cc_class:  string?  ,
cc_employees:  int64?   ,
cc_sq_ft:  int64?   ,
cc_hours:  string?  ,
cc_manager:string?  ,
cc_mkt_id: int64?   ,
cc_mkt_class:  string?  ,
cc_mkt_desc:   string?  ,
cc_market_manager: string?  ,
cc_division:   int64?   ,
cc_division_name:  string?  ,
cc_company:int64?   ,
cc_company_name:   string?  ,
cc_street_number:  int64?   ,
cc_street_name:string?  ,
cc_street_type:string?  ,
cc_suite_number:   string?  ,
cc_city:   string?  ,
cc_county: string?  ,
cc_state:  string?  ,
cc_zip:string?  ,
cc_country:string?  ,
cc_gmt_offset: double?  ,
cc_tax_percentage: double?  
}

create table call_center (call_center_type)
primary key cc_call_center_sk;
{code}

Then load the file call_center.dat

{code}
load  table call_center using localfs ((`path`=`hostname://`),(`format`=`delimited-text`),(`delimiter`=`|`));
{code}

The following exception is thrown:

No value parser factory for fields of type DATE [NotImplementedException]


  was:
To reproduce the issue, create a type and table using sql++ as follows:

{code}
create type call_center_type as closed {
cc_call_center_sk: int64,
cc_call_center_id: string   ,
cc_rec_start_date: date?,
cc_rec_end_date:   date?,
cc_closed_date_sk: int64?   ,
cc_open_date_sk:   int64?   ,
cc_name:   string?  ,
cc_class:  string?  ,
cc_employees:  int64?   ,
cc_sq_ft:  int64?   ,
cc_hours:  string?  ,
cc_manager:string?  ,
cc_mkt_id: int64?   ,
cc_mkt_class:  string?  ,
cc_mkt_desc:   string?  ,
cc_market_manager: string?  ,
cc_division:   int64?   ,
cc_division_name:  string?  ,
cc_company:int64?   ,
cc_company_name:   string?  ,
cc_street_number:  int64?   ,
cc_street_name:string?  ,
cc_street_type:string?  ,
cc_suite_number:   string?  ,
cc_city:   string?  ,
cc_county: string?  ,
cc_state:  string?  ,
cc_zip:string?  ,
cc_country:string?  ,
cc_gmt_offset: double?  ,
cc_tax_percentage: double?  
}

create table call_center (call_center_type)
primary key cc_call_center_sk;
{code}

Then load the file call_center.dat

The following exception is thrown:

[jira] [Created] (ASTERIXDB-1562) NotImplemented Exception thrown when external delimited file is loaded using sql++

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1562:
--

 Summary: NotImplemented Exception thrown when external delimited 
file is loaded using sql++
 Key: ASTERIXDB-1562
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1562
 Project: Apache AsterixDB
  Issue Type: Bug
 Environment: Build 380b0a27
Reporter: Vignesh Raghunathan


To reproduce the issue, create a type and table using sql++ as follows:

create type call_center_type as closed {
cc_call_center_sk: int64,
cc_call_center_id: string   ,
cc_rec_start_date: date?,
cc_rec_end_date:   date?,
cc_closed_date_sk: int64?   ,
cc_open_date_sk:   int64?   ,
cc_name:   string?  ,
cc_class:  string?  ,
cc_employees:  int64?   ,
cc_sq_ft:  int64?   ,
cc_hours:  string?  ,
cc_manager:string?  ,
cc_mkt_id: int64?   ,
cc_mkt_class:  string?  ,
cc_mkt_desc:   string?  ,
cc_market_manager: string?  ,
cc_division:   int64?   ,
cc_division_name:  string?  ,
cc_company:int64?   ,
cc_company_name:   string?  ,
cc_street_number:  int64?   ,
cc_street_name:string?  ,
cc_street_type:string?  ,
cc_suite_number:   string?  ,
cc_city:   string?  ,
cc_county: string?  ,
cc_state:  string?  ,
cc_zip:string?  ,
cc_country:string?  ,
cc_gmt_offset: double?  ,
cc_tax_percentage: double?  
}

create table call_center (call_center_type)
primary key cc_call_center_sk;

Then load the file call_center.dat

The following exception is thrown:

No value parser factory for fields of type DATE [NotImplementedException]




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (ASTERIXDB-1430) Unexpected behavior in datetime constructor

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1430?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15400850#comment-15400850
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1430:


According to the documentation, time and datetime constructors convert the 
given time to UTC. Furthermore, adjust-datetime-for-timezone and 
adjust-time-for-timezone functions convert the given datetime/time values to 
the timezone specified in the second argument and append the timezone in the 
timezone field. 

The given query could be written as 

let $ct := current-datetime()
let $adjustedDatetime := adjust-datetime-for-timezone($ct, "-10:00")
let $nt := datetime($adjustedDatetime)
return {"ct": $ct, "adjustedDateTime": $adjustedDatetime, "nt":$nt}

which gives the result

{ "ct": datetime("2016-07-30T21:41:54.222Z"), "adjustedDateTime": 
"2016-07-30T11:41:54.222-10:00", "nt": datetime("2016-07-30T21:41:54.222Z") }

"adjustedDateTime" holds the datetime value of "ct" converted to -10:00. "nt" 
holds the value of "adjustedDateTime"  converted back to UTC. This is the 
expected behavior of the datetime constructor and adjust-datetime-for-timezone 
functions.


> Unexpected behavior in datetime constructor
> ---
>
> Key: ASTERIXDB-1430
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1430
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: Functions - AQL
>Reporter: Murtadha Hubail
>  Labels: starter
>
> I used the function adjust-datetime-for-timezone(datetime, zone), which 
> returns string type, to adjust the current datetime, then I wanted to use the 
> returned value as datetime type.
> When I tried the following:
> {noformat}
> let $adjustedDatetime := adjust-datetime-for-timezone(current-datetime(), 
> "-10:00")
> return datetime($adjustedDatetime)
> {noformat}
> The returned datetime value lost the adjustment.
> I think the datetime constructor should either respect the adjustment or 
> throw an invalid format exception.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (ASTERIXDB-1430) Unexpected behavior in datetime constructor

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1430?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15392551#comment-15392551
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1430:


I posted the following questions in the mailing list but I didn't get all of 
them answered:

I am trying to step through some of the function descriptor code. For instance, 
I launched an AsterixDB instance via AsterixHyracksIntegrationUtil, placed a 
breakpoint in 

org.apache.asterix.runtime.evaluators.constructors.ATimeConstructorDescriptor.createEvaluatorFactory(...).new
 IScalarEvaluatorFactory() {...}.createScalarEvaluator(...).new 
IScalarEvaluator() {...}.evaluate(IFrameTupleReference, IPointable)

and ran the query 

let $v := time(“12:23:23”)
return $v

However, execution doesn’t stop at the breakpoint. My questions are as follows:

1. http://sigmod.github.io/papers/socc15-final153.pdf mentions runtime 
artifacts called evaluators for function expressions. Is the evaluate function 
mentioned above part of an evaluator for the time constructor?

2. Is a separate JVM launched for each virtual node controller? 

3. How can I debug a task that is scheduled to run in a particular node 
controller?

As an aside, http://sigmod.github.io/papers/socc15-final153.pdf mentions that 
translation between logical functions and evaluators happen during the job 
generation phase. Does that mean the rule based physical optimization phase is 
skipped for functions? 

I am also not able to figure out where the function evaluators are actually 
called in code. Where can I find them?

[~imaxon] [~mjca...@ics.uci.edu] [~tillw] Could you please help?

> Unexpected behavior in datetime constructor
> ---
>
> Key: ASTERIXDB-1430
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1430
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: Functions - AQL
>Reporter: Murtadha Hubail
>  Labels: starter
>
> I used the function adjust-datetime-for-timezone(datetime, zone), which 
> returns string type, to adjust the current datetime, then I wanted to use the 
> returned value as datetime type.
> When I tried the following:
> {noformat}
> let $adjustedDatetime := adjust-datetime-for-timezone(current-datetime(), 
> "-10:00")
> return datetime($adjustedDatetime)
> {noformat}
> The returned datetime value lost the adjustment.
> I think the datetime constructor should either respect the adjustment or 
> throw an invalid format exception.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15392523#comment-15392523
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1546:


Running a maven build again after refreshing projects in eclipse solves this 
issue. 

> Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
> 
>
> Key: ASTERIXDB-1546
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1546
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Eclipse IDE
> Version: Neon Release (4.6.0)
> Build id: 20160613-1800
>Reporter: Vignesh Raghunathan
>
> After launching an AsterixDB instance using 
> AsterixHyracksIntegrationUtil.java, the following exceptions are thrown after 
> a query like abs(-1) is executed.
> 2016-07-25 16:03:00,412 WARN  [qtp1833789138-36] util.log 
> (JCLLoggerAdapter.java:warn(437)) - Error for /
> java.lang.ExceptionInInitializerError
>   at 
> org.apache.asterix.translator.LangExpressionToPlanTranslator.(LangExpressionToPlanTranslator.java:177)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslator.(AqlExpressionToPlanTranslator.java:72)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslatorFactory.createExpressionToPlanTranslator(AqlExpressionToPlanTranslatorFactory.java:31)
>   at 
> org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:208)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1938)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.handleQuery(QueryTranslator.java:2534)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:365)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:258)
>   at 
> org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:130)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
>   at 
> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:546)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:483)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:228)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:956)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:411)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:188)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:891)
>   at 
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
>   at 
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
>   at org.eclipse.jetty.server.Server.handle(Server.java:353)
>   at 
> org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:598)
>   at 
> org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1076)
>   at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805)
>   at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218)
>   at 
> org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:427)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:510)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)
>   at 
> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:450)
>   at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.IllegalStateException: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at 
> org.apache.asterix.translator.util.FunctionCollection.getGeneratedFunctionDescriptorFactory(FunctionCollection.java:643)
>   at 
> org.apache.asterix.translator.util.FunctionCollection.(FunctionCollection.java:618)
>   ... 31 more
> Caused by: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
>   at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
>   at java.security.AccessController.doPrivileged(Native Method)
>   at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
>   at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>   at 

[jira] [Comment Edited] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15392468#comment-15392468
 ] 

Vignesh Raghunathan edited comment on ASTERIXDB-1546 at 7/25/16 7:05 PM:
-

I couldn't find the 'generated' folder under 
asterixdb/asterix-algebra/target/classes/org/apache/asterix/ on the current 
master branch. However, if I checkout commit 8f7c7c6, I can see the 'generated' 
folder after running a maven build.

Edit: I can see the generated folder in the current branch as well. For some 
reason, eclipse deletes the folder after I refresh all the projects. 


was (Author: vignesh.raghunathan90):
I couldn't find the 'generated' folder under 
asterixdb/asterix-algebra/target/classes/org/apache/asterix/ on the current 
master branch. However, if I checkout commit 8f7c7c6, I can see the 'generated' 
folder after running a maven build.



> Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
> 
>
> Key: ASTERIXDB-1546
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1546
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Eclipse IDE
> Version: Neon Release (4.6.0)
> Build id: 20160613-1800
>Reporter: Vignesh Raghunathan
>
> After launching an AsterixDB instance using 
> AsterixHyracksIntegrationUtil.java, the following exceptions are thrown after 
> a query like abs(-1) is executed.
> 2016-07-25 16:03:00,412 WARN  [qtp1833789138-36] util.log 
> (JCLLoggerAdapter.java:warn(437)) - Error for /
> java.lang.ExceptionInInitializerError
>   at 
> org.apache.asterix.translator.LangExpressionToPlanTranslator.(LangExpressionToPlanTranslator.java:177)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslator.(AqlExpressionToPlanTranslator.java:72)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslatorFactory.createExpressionToPlanTranslator(AqlExpressionToPlanTranslatorFactory.java:31)
>   at 
> org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:208)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1938)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.handleQuery(QueryTranslator.java:2534)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:365)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:258)
>   at 
> org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:130)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
>   at 
> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:546)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:483)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:228)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:956)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:411)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:188)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:891)
>   at 
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
>   at 
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
>   at org.eclipse.jetty.server.Server.handle(Server.java:353)
>   at 
> org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:598)
>   at 
> org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1076)
>   at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805)
>   at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218)
>   at 
> org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:427)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:510)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)
>   at 
> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:450)
>   at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.IllegalStateException: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at 
> org.apache.asterix.translator.util.FunctionCollection.getGeneratedFunctionDescriptorFactory(FunctionCollection.java:643)
>  

[jira] [Commented] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15392468#comment-15392468
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1546:


I couldn't find the 'generated' folder under 
asterixdb/asterix-algebra/target/classes/org/apache/asterix/ on the current 
master branch. However, if I checkout commit 8f7c7c6, I can see the 'generated' 
folder after running a maven build.



> Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
> 
>
> Key: ASTERIXDB-1546
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1546
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Eclipse IDE
> Version: Neon Release (4.6.0)
> Build id: 20160613-1800
>Reporter: Vignesh Raghunathan
>
> After launching an AsterixDB instance using 
> AsterixHyracksIntegrationUtil.java, the following exceptions are thrown after 
> a query like abs(-1) is executed.
> 2016-07-25 16:03:00,412 WARN  [qtp1833789138-36] util.log 
> (JCLLoggerAdapter.java:warn(437)) - Error for /
> java.lang.ExceptionInInitializerError
>   at 
> org.apache.asterix.translator.LangExpressionToPlanTranslator.(LangExpressionToPlanTranslator.java:177)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslator.(AqlExpressionToPlanTranslator.java:72)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslatorFactory.createExpressionToPlanTranslator(AqlExpressionToPlanTranslatorFactory.java:31)
>   at 
> org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:208)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1938)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.handleQuery(QueryTranslator.java:2534)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:365)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:258)
>   at 
> org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:130)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
>   at 
> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:546)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:483)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:228)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:956)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:411)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:188)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:891)
>   at 
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
>   at 
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
>   at org.eclipse.jetty.server.Server.handle(Server.java:353)
>   at 
> org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:598)
>   at 
> org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1076)
>   at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805)
>   at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218)
>   at 
> org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:427)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:510)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)
>   at 
> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:450)
>   at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.IllegalStateException: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at 
> org.apache.asterix.translator.util.FunctionCollection.getGeneratedFunctionDescriptorFactory(FunctionCollection.java:643)
>   at 
> org.apache.asterix.translator.util.FunctionCollection.(FunctionCollection.java:618)
>   ... 31 more
> Caused by: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
>   at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
>   at java.security.AccessController.doPrivileged(Native Method)
>   at 

[jira] [Commented] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15391762#comment-15391762
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1546:


The issue still occurs after running mvn install and mvn package.

> Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
> 
>
> Key: ASTERIXDB-1546
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1546
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Eclipse IDE
> Version: Neon Release (4.6.0)
> Build id: 20160613-1800
>Reporter: Vignesh Raghunathan
>
> After launching an AsterixDB instance using 
> AsterixHyracksIntegrationUtil.java, the following exceptions are thrown after 
> a query like abs(-1) is executed.
> 2016-07-25 16:03:00,412 WARN  [qtp1833789138-36] util.log 
> (JCLLoggerAdapter.java:warn(437)) - Error for /
> java.lang.ExceptionInInitializerError
>   at 
> org.apache.asterix.translator.LangExpressionToPlanTranslator.(LangExpressionToPlanTranslator.java:177)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslator.(AqlExpressionToPlanTranslator.java:72)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslatorFactory.createExpressionToPlanTranslator(AqlExpressionToPlanTranslatorFactory.java:31)
>   at 
> org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:208)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1938)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.handleQuery(QueryTranslator.java:2534)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:365)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:258)
>   at 
> org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:130)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
>   at 
> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:546)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:483)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:228)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:956)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:411)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:188)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:891)
>   at 
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
>   at 
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
>   at org.eclipse.jetty.server.Server.handle(Server.java:353)
>   at 
> org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:598)
>   at 
> org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1076)
>   at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805)
>   at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218)
>   at 
> org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:427)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:510)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)
>   at 
> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:450)
>   at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.IllegalStateException: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at 
> org.apache.asterix.translator.util.FunctionCollection.getGeneratedFunctionDescriptorFactory(FunctionCollection.java:643)
>   at 
> org.apache.asterix.translator.util.FunctionCollection.(FunctionCollection.java:618)
>   ... 31 more
> Caused by: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
>   at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
>   at java.security.AccessController.doPrivileged(Native Method)
>   at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
>   at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>   at 

[jira] [Commented] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15391719#comment-15391719
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1546:


I tried with a new clone of the repository, deleted .m2/repository folder and 
created a new workspace. The problem still occurs. However, older commits don't 
have this problem.

> Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
> 
>
> Key: ASTERIXDB-1546
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1546
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Eclipse IDE
> Version: Neon Release (4.6.0)
> Build id: 20160613-1800
>Reporter: Vignesh Raghunathan
>
> After launching an AsterixDB instance using 
> AsterixHyracksIntegrationUtil.java, the following exceptions are thrown after 
> a query like abs(-1) is executed.
> 2016-07-25 16:03:00,412 WARN  [qtp1833789138-36] util.log 
> (JCLLoggerAdapter.java:warn(437)) - Error for /
> java.lang.ExceptionInInitializerError
>   at 
> org.apache.asterix.translator.LangExpressionToPlanTranslator.(LangExpressionToPlanTranslator.java:177)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslator.(AqlExpressionToPlanTranslator.java:72)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslatorFactory.createExpressionToPlanTranslator(AqlExpressionToPlanTranslatorFactory.java:31)
>   at 
> org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:208)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1938)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.handleQuery(QueryTranslator.java:2534)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:365)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:258)
>   at 
> org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:130)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
>   at 
> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:546)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:483)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:228)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:956)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:411)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:188)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:891)
>   at 
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
>   at 
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
>   at org.eclipse.jetty.server.Server.handle(Server.java:353)
>   at 
> org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:598)
>   at 
> org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1076)
>   at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805)
>   at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218)
>   at 
> org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:427)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:510)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)
>   at 
> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:450)
>   at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.IllegalStateException: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at 
> org.apache.asterix.translator.util.FunctionCollection.getGeneratedFunctionDescriptorFactory(FunctionCollection.java:643)
>   at 
> org.apache.asterix.translator.util.FunctionCollection.(FunctionCollection.java:618)
>   ... 31 more
> Caused by: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
>   at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
>   at java.security.AccessController.doPrivileged(Native Method)
>   at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
>   at 

[jira] [Updated] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan updated ASTERIXDB-1546:
---
Environment: 
Eclipse IDE

Version: Neon Release (4.6.0)
Build id: 20160613-1800

> Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
> 
>
> Key: ASTERIXDB-1546
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1546
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Eclipse IDE
> Version: Neon Release (4.6.0)
> Build id: 20160613-1800
>Reporter: Vignesh Raghunathan
>
> After launching an AsterixDB instance using 
> AsterixHyracksIntegrationUtil.java, the following exceptions are thrown after 
> a query like abs(-1) is executed.
> 2016-07-25 16:03:00,412 WARN  [qtp1833789138-36] util.log 
> (JCLLoggerAdapter.java:warn(437)) - Error for /
> java.lang.ExceptionInInitializerError
>   at 
> org.apache.asterix.translator.LangExpressionToPlanTranslator.(LangExpressionToPlanTranslator.java:177)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslator.(AqlExpressionToPlanTranslator.java:72)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslatorFactory.createExpressionToPlanTranslator(AqlExpressionToPlanTranslatorFactory.java:31)
>   at 
> org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:208)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1938)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.handleQuery(QueryTranslator.java:2534)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:365)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:258)
>   at 
> org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:130)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
>   at 
> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:546)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:483)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:228)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:956)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:411)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:188)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:891)
>   at 
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
>   at 
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
>   at org.eclipse.jetty.server.Server.handle(Server.java:353)
>   at 
> org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:598)
>   at 
> org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1076)
>   at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805)
>   at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218)
>   at 
> org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:427)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:510)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)
>   at 
> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:450)
>   at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.IllegalStateException: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at 
> org.apache.asterix.translator.util.FunctionCollection.getGeneratedFunctionDescriptorFactory(FunctionCollection.java:643)
>   at 
> org.apache.asterix.translator.util.FunctionCollection.(FunctionCollection.java:618)
>   ... 31 more
> Caused by: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
>   at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
>   at java.security.AccessController.doPrivileged(Native Method)
>   at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
>   at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>   at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
>   at 

[jira] [Updated] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan updated ASTERIXDB-1546:
---
Description: 
After launching an AsterixDB instance using AsterixHyracksIntegrationUtil.java, 
the following exceptions are thrown after a query like abs(-1) is executed.

2016-07-25 16:03:00,412 WARN  [qtp1833789138-36] util.log 
(JCLLoggerAdapter.java:warn(437)) - Error for /
java.lang.ExceptionInInitializerError
at 
org.apache.asterix.translator.LangExpressionToPlanTranslator.(LangExpressionToPlanTranslator.java:177)
at 
org.apache.asterix.translator.AqlExpressionToPlanTranslator.(AqlExpressionToPlanTranslator.java:72)
at 
org.apache.asterix.translator.AqlExpressionToPlanTranslatorFactory.createExpressionToPlanTranslator(AqlExpressionToPlanTranslatorFactory.java:31)
at 
org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:208)
at 
org.apache.asterix.aql.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1938)
at 
org.apache.asterix.aql.translator.QueryTranslator.handleQuery(QueryTranslator.java:2534)
at 
org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:365)
at 
org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:258)
at 
org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at 
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:546)
at 
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:483)
at 
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:228)
at 
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:956)
at 
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:411)
at 
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:188)
at 
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:891)
at 
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at 
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
at org.eclipse.jetty.server.Server.handle(Server.java:353)
at 
org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:598)
at 
org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1076)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218)
at 
org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:427)
at 
org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:510)
at 
org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34)
at 
org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)
at 
org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:450)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalStateException: java.lang.ClassNotFoundException: 
org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
at 
org.apache.asterix.translator.util.FunctionCollection.getGeneratedFunctionDescriptorFactory(FunctionCollection.java:643)
at 
org.apache.asterix.translator.util.FunctionCollection.(FunctionCollection.java:618)
... 31 more
Caused by: java.lang.ClassNotFoundException: 
org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at 
org.apache.asterix.translator.util.FunctionCollection.getGeneratedFunctionDescriptorFactory(FunctionCollection.java:639)
... 32 more

  was:
After launching an AsterixDB instance using AsterixHyracksIntegrationUtil.java, 
the following exceptions are thrown after a query is executed. No results are 
displayed.

2016-07-25 16:03:00,412 WARN  [qtp1833789138-36] util.log 
(JCLLoggerAdapter.java:warn(437)) - Error for /
java.lang.ExceptionInInitializerError
at 

[jira] [Commented] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15391690#comment-15391690
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1546:


The issue occurs at commit 973a0d34e36de2fb950f4979843b3bef9f1f992d and after

> Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
> 
>
> Key: ASTERIXDB-1546
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1546
> Project: Apache AsterixDB
>  Issue Type: Bug
>Reporter: Vignesh Raghunathan
>
> After launching an AsterixDB instance using 
> AsterixHyracksIntegrationUtil.java, the following exceptions are thrown after 
> a query is executed. No results are displayed.
> 2016-07-25 16:03:00,412 WARN  [qtp1833789138-36] util.log 
> (JCLLoggerAdapter.java:warn(437)) - Error for /
> java.lang.ExceptionInInitializerError
>   at 
> org.apache.asterix.translator.LangExpressionToPlanTranslator.(LangExpressionToPlanTranslator.java:177)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslator.(AqlExpressionToPlanTranslator.java:72)
>   at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslatorFactory.createExpressionToPlanTranslator(AqlExpressionToPlanTranslatorFactory.java:31)
>   at 
> org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:208)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1938)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.handleQuery(QueryTranslator.java:2534)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:365)
>   at 
> org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:258)
>   at 
> org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:130)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
>   at 
> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:546)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:483)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:228)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:956)
>   at 
> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:411)
>   at 
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:188)
>   at 
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:891)
>   at 
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
>   at 
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
>   at org.eclipse.jetty.server.Server.handle(Server.java:353)
>   at 
> org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:598)
>   at 
> org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1076)
>   at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805)
>   at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218)
>   at 
> org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:427)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:510)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34)
>   at 
> org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)
>   at 
> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:450)
>   at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.IllegalStateException: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at 
> org.apache.asterix.translator.util.FunctionCollection.getGeneratedFunctionDescriptorFactory(FunctionCollection.java:643)
>   at 
> org.apache.asterix.translator.util.FunctionCollection.(FunctionCollection.java:618)
>   ... 31 more
> Caused by: java.lang.ClassNotFoundException: 
> org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
>   at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
>   at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
>   at java.security.AccessController.doPrivileged(Native Method)
>   at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
>   at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>   at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
>   at 

[jira] [Created] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1546:
--

 Summary: Exceptions thrown after launching 
AsterixHyracksIntegrationUtil.java
 Key: ASTERIXDB-1546
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1546
 Project: Apache AsterixDB
  Issue Type: Bug
Reporter: Vignesh Raghunathan


After launching an AsterixDB instance using AsterixHyracksIntegrationUtil.java, 
the following exceptions are thrown after a query is executed. No results are 
displayed.

2016-07-25 16:03:00,412 WARN  [qtp1833789138-36] util.log 
(JCLLoggerAdapter.java:warn(437)) - Error for /
java.lang.ExceptionInInitializerError
at 
org.apache.asterix.translator.LangExpressionToPlanTranslator.(LangExpressionToPlanTranslator.java:177)
at 
org.apache.asterix.translator.AqlExpressionToPlanTranslator.(AqlExpressionToPlanTranslator.java:72)
at 
org.apache.asterix.translator.AqlExpressionToPlanTranslatorFactory.createExpressionToPlanTranslator(AqlExpressionToPlanTranslatorFactory.java:31)
at 
org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:208)
at 
org.apache.asterix.aql.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1938)
at 
org.apache.asterix.aql.translator.QueryTranslator.handleQuery(QueryTranslator.java:2534)
at 
org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:365)
at 
org.apache.asterix.aql.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:258)
at 
org.apache.asterix.api.http.servlet.APIServlet.doPost(APIServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at 
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:546)
at 
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:483)
at 
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:228)
at 
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:956)
at 
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:411)
at 
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:188)
at 
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:891)
at 
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at 
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114)
at org.eclipse.jetty.server.Server.handle(Server.java:353)
at 
org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:598)
at 
org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1076)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218)
at 
org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:427)
at 
org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:510)
at 
org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34)
at 
org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)
at 
org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:450)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalStateException: java.lang.ClassNotFoundException: 
org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
at 
org.apache.asterix.translator.util.FunctionCollection.getGeneratedFunctionDescriptorFactory(FunctionCollection.java:643)
at 
org.apache.asterix.translator.util.FunctionCollection.(FunctionCollection.java:618)
... 31 more
Caused by: java.lang.ClassNotFoundException: 
org.apache.asterix.generated.runtime.evaluators.functions.records.FieldAccessByIndexGen
at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at 
org.apache.asterix.translator.util.FunctionCollection.getGeneratedFunctionDescriptorFactory(FunctionCollection.java:639)
... 32 more



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (ASTERIXDB-1519) Unable to load data from local filesystem

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1519?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15371449#comment-15371449
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1519:


The slave process wasn't running on the node containing data. 

> Unable to load data from local filesystem
> -
>
> Key: ASTERIXDB-1519
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1519
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Packaged from source code with latest commit 
> b7551d1a2e3dcaef63a7ccdf3efe18b345685b23
>Reporter: Vignesh Raghunathan
>
> Sample Query:
> use dataverse TinySocial;
> load dataset FacebookUsers using localfs
> (("path"="176.45.33.258:///home/sampuser/fbu.adm"),("format"="adm"));
> where 176.45.33.258 has the cluster controller running
> Result:
> Error
> No node controllers found at the address: 176.45.33.258  [AsterixException]



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (ASTERIXDB-1519) Unable to load data from local filesystem

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1519:
--

 Summary: Unable to load data from local filesystem
 Key: ASTERIXDB-1519
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1519
 Project: Apache AsterixDB
  Issue Type: Bug
 Environment: Packaged from source code with latest commit 
b7551d1a2e3dcaef63a7ccdf3efe18b345685b23
Reporter: Vignesh Raghunathan


Sample Query:

use dataverse TinySocial;

load dataset FacebookUsers using localfs
(("path"="176.45.33.258:///home/sampuser/fbu.adm"),("format"="adm"));

where 176.45.33.258 has the cluster controller running

Result:

Error
No node controllers found at the address: 176.45.33.258  [AsterixException]



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (ASTERIXDB-1513) Error in POM file after importing to eclipse

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan updated ASTERIXDB-1513:
---
Attachment: Screen Shot 2016-07-06 at 1.11.04 PM.png
Screen Shot 2016-07-06 at 1.05.09 PM.png

> Error in POM file after importing to eclipse
> 
>
> Key: ASTERIXDB-1513
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1513
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Mac OSX El Capitan 10.11.5
> Eclipse Mars.2 Release (4.5.2)
> Apache Maven 3.3.9
> m2e 1.7.0.20160603-1933
>Reporter: Vignesh Raghunathan
>Assignee: Taewoo Kim
>Priority: Blocker
> Attachments: Screen Shot 2016-07-03 at 3.17.01 PM.png, Screen Shot 
> 2016-07-06 at 1.05.09 PM.png, Screen Shot 2016-07-06 at 1.11.04 PM.png
>
>
> After importing hyracks and asterixdb projects into eclipse, there are errors 
> in the POM file in many hyracks projects. I followed all steps in 
> https://asterixdb.apache.org/dev-setup.html for setting up asterixdb 
> environment in eclipse



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (ASTERIXDB-1513) Error in POM file after importing to eclipse

[Vignesh Raghunathan (JIRA)]

[ 
https://issues.apache.org/jira/browse/ASTERIXDB-1513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15363920#comment-15363920
 ] 

Vignesh Raghunathan commented on ASTERIXDB-1513:


That fixed most of the errors. asterix-app and asterix-external-data packages 
still have errors. I have included screenshots.

> Error in POM file after importing to eclipse
> 
>
> Key: ASTERIXDB-1513
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1513
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Mac OSX El Capitan 10.11.5
> Eclipse Mars.2 Release (4.5.2)
> Apache Maven 3.3.9
> m2e 1.7.0.20160603-1933
>Reporter: Vignesh Raghunathan
>Assignee: Taewoo Kim
>Priority: Blocker
> Attachments: Screen Shot 2016-07-03 at 3.17.01 PM.png
>
>
> After importing hyracks and asterixdb projects into eclipse, there are errors 
> in the POM file in many hyracks projects. I followed all steps in 
> https://asterixdb.apache.org/dev-setup.html for setting up asterixdb 
> environment in eclipse



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (ASTERIXDB-1513) Error in POM file after importing to eclipse

[Vignesh Raghunathan (JIRA)]

 [ 
https://issues.apache.org/jira/browse/ASTERIXDB-1513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vignesh Raghunathan updated ASTERIXDB-1513:
---
Attachment: Screen Shot 2016-07-03 at 3.17.01 PM.png

> Error in POM file after importing to eclipse
> 
>
> Key: ASTERIXDB-1513
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1513
> Project: Apache AsterixDB
>  Issue Type: Bug
> Environment: Mac OSX El Capitan 10.11.5
> Eclipse Mars.2 Release (4.5.2)
> Apache Maven 3.3.9
> m2e 1.7.0.20160603-1933
>Reporter: Vignesh Raghunathan
>Priority: Blocker
> Attachments: Screen Shot 2016-07-03 at 3.17.01 PM.png
>
>
> After importing hyracks and asterixdb projects into eclipse, there are errors 
> in the POM file in many hyracks projects. I followed all steps in 
> https://asterixdb.apache.org/dev-setup.html for setting up asterixdb 
> environment in eclipse



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (ASTERIXDB-1513) Error in POM file after importing to eclipse

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1513:
--

 Summary: Error in POM file after importing to eclipse
 Key: ASTERIXDB-1513
 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1513
 Project: Apache AsterixDB
  Issue Type: Bug
 Environment: Mac OSX El Capitan 10.11.5
Eclipse Mars.2 Release (4.5.2)
Apache Maven 3.3.9
m2e 1.7.0.20160603-1933
Reporter: Vignesh Raghunathan
Priority: Blocker


After importing hyracks and asterixdb projects into eclipse, there are errors 
in the POM file in many hyracks projects. I followed all steps in 
https://asterixdb.apache.org/dev-setup.html for setting up asterixdb 
environment in eclipse



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)