[jira] [Closed] (ASTERIXDB-1580) Subquery in having clause throws ArrayIndexOutOfBoundsException
[
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] [Created] (ASTERIXDB-1632) Query having subquery referring to with clause returns incorrect results
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] [Created] (ASTERIXDB-1677) Query with aggregate functions in with and where clause doesn't return result
Vignesh Raghunathan created ASTERIXDB-1677:
--
Summary: Query with aggregate functions in with and where clause
doesn't return result
Key: ASTERIXDB-1677
URL: https://issues.apache.org/jira/browse/ASTERIXDB-1677
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-1676) Query with aggregate functions in with and where clause doesn't return result
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-1678) Precision argument for round function
Vignesh Raghunathan created ASTERIXDB-1678: -- Summary: Precision argument for round function Key: ASTERIXDB-1678 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1678 Project: Apache AsterixDB Issue Type: Improvement Reporter: Vignesh Raghunathan The round function could have a second optional argument for precision similar to the round_half_to_even function -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (ASTERIXDB-1679) Unused horizontal space in builtin functions documentation
Vignesh Raghunathan created ASTERIXDB-1679: -- Summary: Unused horizontal space in builtin functions documentation Key: ASTERIXDB-1679 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1679 Project: Apache AsterixDB Issue Type: Improvement Components: Documentation Reporter: Vignesh Raghunathan In builtin functions documentation, the first line in the interval section could be broken down into several lines. It is making the overall horizontal layout of the document huge. -- 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
[
https://issues.apache.org/jira/browse/ASTERIXDB-1676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15550404#comment-15550404
]
Vignesh Raghunathan commented on ASTERIXDB-1676:
The query hangs. I haven't loaded the datasets with data and I've set the limit
to 1.
> 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] [Closed] (ASTERIXDB-1676) Query with aggregate functions in with and where clause doesn't return result
[
https://issues.apache.org/jira/browse/ASTERIXDB-1676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vignesh Raghunathan closed ASTERIXDB-1676.
--
Resolution: Not A Problem
> 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] [Commented] (ASTERIXDB-1676) Query with aggregate functions in with and where clause doesn't return result
[
https://issues.apache.org/jira/browse/ASTERIXDB-1676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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-1692) Case statement referring to aggregated value throws ArrayIndexOutOfBoundsException
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] [Created] (ASTERIXDB-1697) Joining results of with throws NullPointerException
Vignesh Raghunathan created ASTERIXDB-1697:
--
Summary: 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
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] [Updated] (ASTERIXDB-1697) Joining results of with throws NullPointerException
[
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-1713) Can't select fields if query contains union all clause with select * in from clause
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] [Created] (ASTERIXDB-1712) Can't select fields if query contains union all clause with select * in from clause
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] [Closed] (ASTERIXDB-1712) Can't select fields if query contains union all clause with select * in from clause
[
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-1715) Clause spelled incorrectly in SQL++ documentation
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] [Created] (ASTERIXDB-1513) Error in POM file after importing to eclipse
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)
[jira] [Updated] (ASTERIXDB-1513) Error in POM file after importing to eclipse
[ 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] [Commented] (ASTERIXDB-1513) Error in POM file after importing to eclipse
[ https://issues.apache.org/jira/browse/ASTERIXDB-1513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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
[ 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] [Created] (ASTERIXDB-1519) Unable to load data from local filesystem
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] [Commented] (ASTERIXDB-1513) Error in POM file after importing to eclipse
[ https://issues.apache.org/jira/browse/ASTERIXDB-1513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15364768#comment-15364768 ] Vignesh Raghunathan commented on ASTERIXDB-1513: I tried step 6 to solve the first issue but I couldn't find an edu folder under target -> generated sources > 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] [Closed] (ASTERIXDB-1513) Error in POM file after importing to eclipse
[ https://issues.apache.org/jira/browse/ASTERIXDB-1513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vignesh Raghunathan closed ASTERIXDB-1513. -- The steps in updated document fixed the error in asterix-app > 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-1519) Unable to load data from local filesystem
[
https://issues.apache.org/jira/browse/ASTERIXDB-1519?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
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-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
[ https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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 java.lang.ClassLoader.loadClass(Cl
[jira] [Updated] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
[ 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 org.apache.asterix.translator.LangExpressionToPlanTranslator.(Lang
[jira] [Commented] (ASTERIXDB-1519) Unable to load data from local filesystem
[
https://issues.apache.org/jira/browse/ASTERIXDB-1519?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15391693#comment-15391693
]
Vignesh Raghunathan commented on ASTERIXDB-1519:
Please document the behavior in
https://ci.apache.org/projects/asterixdb/aql/primer.html
Under Loading Data into AsterixDB section, it says the.adm files could be
stored in any filesystem directly accessible to the running AsterixDB instance.
> 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] [Comment Edited] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
[ https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15391690#comment-15391690 ] Vignesh Raghunathan edited comment on ASTERIXDB-1546 at 7/25/16 11:11 AM: -- The issue occurs at commit 3044e2efc2a88f4332ab35b80ce1a20edaae53b2 and after was (Author: vignesh.raghunathan90): 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 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.ClassLo
[jira] [Updated] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
[ 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 java.
[jira] [Commented] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
[ https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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) >
[jira] [Commented] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
[ https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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 sun.misc.Launcher$AppClassLoader.loadCl
[jira] [Commented] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
[ https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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) > a
[jira] [Comment Edited] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
[ https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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.
[jira] [Commented] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
[ https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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 sun.misc.Launcher$A
[jira] [Commented] (ASTERIXDB-1430) Unexpected behavior in datetime constructor
[
https://issues.apache.org/jira/browse/ASTERIXDB-1430?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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
[ https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15399403#comment-15399403 ] Vignesh Raghunathan commented on ASTERIXDB-1546: I couldn't figure how to make changes to the docs to propose a patch. Where should I make the changes? > 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 s
[jira] [Commented] (ASTERIXDB-1430) Unexpected behavior in datetime constructor
[
https://issues.apache.org/jira/browse/ASTERIXDB-1430?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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] [Created] (ASTERIXDB-1562) NotImplemented Exception thrown when external delimited file is loaded using sql++
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] [Issue Comment Deleted] (ASTERIXDB-1562) NotImplemented Exception thrown when external delimited file is loaded using sql++
[
https://issues.apache.org/jira/browse/ASTERIXDB-1562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vignesh Raghunathan updated ASTERIXDB-1562:
---
Comment: was deleted
(was: Delimited data file)
> 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
> 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] [Updated] (ASTERIXDB-1562) NotImplemented Exception thrown when external delimited file is loaded using sql++
[
https://issues.apache.org/jira/browse/ASTERIXDB-1562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vignesh Raghunathan updated ASTERIXDB-1562:
---
Attachment: call_center.dat
Delimited data file
> 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
> 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] [Updated] (ASTERIXDB-1562) NotImplemented Exception thrown when external delimited file is loaded using sql++
[
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:
N
[jira] [Updated] (ASTERIXDB-1562) NotImplemented Exception thrown when external delimited file is loaded using sql++
[
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
org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.lambda$initi
[jira] [Commented] (ASTERIXDB-1562) NotImplemented Exception thrown when external delimited file is loaded using sql++
[
https://issues.apache.org/jira/browse/ASTERIXDB-1562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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:
> org.apache.hyracks.api.exceptions.HyracksDataException: No value parser
> fac
[jira] [Updated] (ASTERIXDB-1571) Subquery in from clause throws NullPointerException
[
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
org.eclipse.jetty.server.handler.ScopedHandl
[jira] [Updated] (ASTERIXDB-1571) Subquery in from clause throws NullPointerException
[
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
org.eclipse.jetty.server.handler.ScopedHandler.h
[jira] [Updated] (ASTERIXDB-1571) Subquery in from clause throws NullPointerException
[
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
org.eclipse.jetty.server.
[jira] [Updated] (ASTERIXDB-1571) Subquery in from clause throws NullPointerException
[
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
org.eclipse.jetty.server.handler.ScopedHand
[jira] [Updated] (ASTERIXDB-1571) Subquery in from clause throws NullPointerException
[
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:
{{monospaced}}
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.Sco
[jira] [Created] (ASTERIXDB-1571) Subquery in from clause throws NullPointerException
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
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler
[jira] [Created] (ASTERIXDB-1572) Multiple and/or conditions in where clause inside a subquery in from clause throws AlgebricksException
Vignesh Raghunathan created ASTERIXDB-1572:
--
Summary: Multiple and/or conditions in where clause inside a
subquery in from clause throws AlgebricksException
Key: ASTERIXDB-1572
URL: https://issues.apache.org/jira/browse/ASTERIXDB-1572
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: int8
};
create dataset samptable(samptabletype) primary key id;
insert into samptable ({'id' : 0});
insert into samptable ({'id' : 1});
select *
from
(
select id from samptable
where (id in [0] and id in [1])
or (id in [1] and id in [2])
) st1;
{code}
Result:
{code}
org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Attempting
to construct a nested plan with 4 operator descriptors. Currently, nested plans
can only consist in linear pipelines of Asterix micro operators.
at
org.apache.hyracks.algebricks.core.algebra.operators.physical.AbstractPhysicalOperator.buildPipelineWithProjection(AbstractPhysicalOperator.java:144)
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
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.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.compiler.api.HeuristicCompilerFactoryBuilder$1$1.createJob(HeuristicCompilerFactoryBuilder.java:107)
at
org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:336)
at
org.apache.asterix.aql.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator
[jira] [Created] (ASTERIXDB-1574) Result of subquery in where clause could not be cast to a scalar value
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
org.apache.asterix.aql.translator.QueryTranslator.handleQuery(QueryTransla
[jira] [Commented] (ASTERIXDB-1571) Subquery in from clause throws NullPointerException
[
https://issues.apache.org/jira/browse/ASTERIXDB-1571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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)
>
[jira] [Commented] (ASTERIXDB-1478) using localfs goes wrong
[
https://issues.apache.org/jira/browse/ASTERIXDB-1478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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
[
https://issues.apache.org/jira/browse/ASTERIXDB-1571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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)
>
[jira] [Created] (ASTERIXDB-1576) Select * with more than two tables in from clause without aliases throws AlgebricksException
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
org.ecli
[jira] [Commented] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
[ https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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) >
[jira] [Commented] (ASTERIXDB-1562) NotImplemented Exception thrown when external delimited file is loaded using sql++
[
https://issues.apache.org/jira/browse/ASTERIXDB-1562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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(
[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 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
org.apache.asterix.api.common.APIFramework.compileQuer
[jira] [Commented] (ASTERIXDB-1571) Subquery in from clause throws NullPointerException
[
https://issues.apache.org/jira/browse/ASTERIXDB-1571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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 javax.servlet.http.
[jira] [Commented] (ASTERIXDB-1574) Result of subquery in where clause could not be cast to a scalar value
[
https://issues.apache.org/jira/browse/ASTERIXDB-1574?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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
> org.apache.hyracks.algebricks.core.rewriter.base.
[jira] [Created] (ASTERIXDB-1580) Subquery in having clause throws ArrayIndexOutOfBoundsException
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] [Updated] (ASTERIXDB-1580) Subquery in having clause throws ArrayIndexOutOfBoundsException
[
https://issues.apache.org/jira/browse/ASTERIXDB-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vignesh Raghunathan updated ASTERIXDB-1580:
---
Attachment: logs.zip
> 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] [Commented] (ASTERIXDB-1580) Subquery in having clause throws ArrayIndexOutOfBoundsException
[
https://issues.apache.org/jira/browse/ASTERIXDB-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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-1581) Subquery inside case when clause - ConcurrentModificationException is thrown
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
org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.rewriteSubplanOperator(InlineSubplanIn
[jira] [Updated] (ASTERIXDB-1581) Subquery inside case when clause - ConcurrentModificationException is thrown
[
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
> org.apache.asterix.optimizer.rules.subplan.InlineSubplanInputForNestedTupleSourceRule.rewriteSubplanOperator(InlineSubplanInputForNeste
[jira] [Created] (ASTERIXDB-1583) Confusing error message produced after including fields in select clause not included in group by
Vignesh Raghunathan created ASTERIXDB-1583:
--
Summary: Confusing error message produced after including fields
in select clause not included in group by
Key: ASTERIXDB-1583
URL: https://issues.apache.org/jira/browse/ASTERIXDB-1583
Project: Apache AsterixDB
Issue Type: Bug
Environment: Master branch with latest commit 33dfae50935b82ac
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 {
id1: int8,
id2:int8?
};
create dataset samptable1(samptabletype) primary key id1;
insert into samptable1 ({'id1' : 0, 'id2':1});
insert into samptable1 ({'id1' : 2, 'id2':1});
select id1 from samptable1 group by id2;
{code}
Result:
{code}
org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Cannot
find dataset id1 in dataverse sampdb nor an alias with name id1
at
org.apache.asterix.optimizer.rules.ResolveVariableRule.resolveInternal(ResolveVariableRule.java:173)
at
org.apache.asterix.optimizer.rules.ResolveVariableRule.resolve(ResolveVariableRule.java:123)
at
org.apache.asterix.optimizer.rules.ResolveVariableRule.rewriteExpressionReference(ResolveVariableRule.java:109)
at
org.apache.asterix.optimizer.rules.ResolveVariableRule.rewriteExpressionReference(ResolveVariableRule.java:98)
at
org.apache.asterix.optimizer.rules.ResolveVariableRule.lambda$0(ResolveVariableRule.java:77)
at
org.apache.asterix.optimizer.rules.ResolveVariableRule$$Lambda$25/800935469.transform(Unknown
Source)
at
org.apache.hyracks.algebricks.core.algebra.operators.logical.AbstractAssignOperator.acceptExpressionTransform(AbstractAssignOperator.java:67)
at
org.apache.asterix.optimizer.rules.ResolveVariableRule.rewritePost(ResolveVariableRule.java:76)
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
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
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)
at org.eclipse.jetty.io.FillInterest.
[jira] [Commented] (ASTERIXDB-1546) Exceptions thrown after launching AsterixHyracksIntegrationUtil.java
[ https://issues.apache.org/jira/browse/ASTERIXDB-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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
[jira] [Created] (ASTERIXDB-1591) Multiple exists in where throws NullPointerException
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
org.apache.hyracks.algebricks.core.jobgen.impl.PlanComp
[jira] [Updated] (ASTERIXDB-1591) Multiple exists in where throws NullPointerException
[
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
> org.apache.hyracks.al
[jira] [Created] (ASTERIXDB-1592) Combining SQL-92 type join and left outer join throws NullPointerException
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
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(A
[jira] [Created] (ASTERIXDB-1597) Ordering by aggregated field throws NullPointerException
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
org.eclipse.jetty.server.handler.HandlerWrap
[jira] [Reopened] (ASTERIXDB-1580) Subquery in having clause throws ArrayIndexOutOfBoundsException
[
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] [Commented] (ASTERIXDB-1580) Subquery in having clause throws ArrayIndexOutOfBoundsException
[
https://issues.apache.org/jira/browse/ASTERIXDB-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15429365#comment-15429365
]
Vignesh Raghunathan commented on ASTERIXDB-1580:
Reopened because the two queries "select value a from stategrp" looks
equivalent to "select value stategrp.a from stategrp"
I understand that a is syntactic sugar for the second query after the group by
clause but I don't get why that's stopping the first query from working. Could
you elaborate on the 'materialization of the value a' part?
> 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-1598) Grouping by columns with same name throws error
Vignesh Raghunathan created ASTERIXDB-1598:
--
Summary: Grouping by columns with same name throws error
Key: ASTERIXDB-1598
URL: https://issues.apache.org/jira/browse/ASTERIXDB-1598
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 samptabletype1 as closed {
id: int64
};
create type samptabletype2 as closed {
id: int64
};
create dataset samptable1(samptabletype1) primary key id;
create dataset samptable2(samptabletype2) primary key id;
select *
from samptable1 s1, samptable2 s2
group by s1.id, s2.id;
{code}
Result:
{code}
Error: Duplicate alias definitions: id
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Created] (ASTERIXDB-1600) Support for date arthimetic
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] [Created] (ASTERIXDB-1602) Nest subqueries in with clause throws StackOverflowError
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] [Updated] (ASTERIXDB-1602) Nested subqueries in with clause throws StackOverflowError
[
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] [Updated] (ASTERIXDB-1602) Nested subqueries in with clause throws StackOverflowError
[
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-1600) Support for date arthimetic
[
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-1600) Support for date and string arthimetic
[
https://issues.apache.org/jira/browse/ASTERIXDB-1600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vignesh Raghunathan updated ASTERIXDB-1600:
---
Summary: Support for date and string arthimetic (was: Support for date
arthimetic)
> Support for date and string 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)
