[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)