Change in asterixdb[master]: Feed tutorial revise.
Jenkins has posted comments on this change. Change subject: Feed tutorial revise. .. Patch Set 3: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-notopic/2949/ -- To view, visit https://asterix-gerrit.ics.uci.edu/1152 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: I110e2225a3036109bf58a9ef529407de955335ab Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Xikui WangGerrit-Reviewer: Ian Maxon Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: Feed tutorial revise.
Ian Maxon has posted comments on this change. Change subject: Feed tutorial revise. .. Patch Set 3: Code-Review+2 -- To view, visit https://asterix-gerrit.ics.uci.edu/1152 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: I110e2225a3036109bf58a9ef529407de955335ab Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Xikui WangGerrit-Reviewer: Ian Maxon Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: Make terminologies consistent in docs.
Jenkins has posted comments on this change. Change subject: Make terminologies consistent in docs. .. Patch Set 1: Integration Tests Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-integration-tests/867/ -- To view, visit https://asterix-gerrit.ics.uci.edu/1258 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: I35a647601441a48bb5576b115324fb0dc6eae176 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Yingyi BuGerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: Add type check functions and their docs, including:
Till Westmann has posted comments on this change. Change subject: Add type check functions and their docs, including: .. Patch Set 3: (1 comment) https://asterix-gerrit.ics.uci.edu/#/c/1257/3/asterixdb/asterix-doc/src/main/markdown/builtins/11_type.md File asterixdb/asterix-doc/src/main/markdown/builtins/11_type.md: Line 38: "a": is_array(true), I think that we have no tests for the "_" version. Do we really need 3 versions? -- To view, visit https://asterix-gerrit.ics.uci.edu/1257 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Id12067dbd89f74a6c1248eb7ac6504400a67cbf6 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Yingyi BuGerrit-Reviewer: Jenkins Gerrit-Reviewer: Till Westmann Gerrit-HasComments: Yes
[jira] [Commented] (ASTERIXDB-1683) About the test issues.
[ https://issues.apache.org/jira/browse/ASTERIXDB-1683?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15553382#comment-15553382 ] Ian Maxon commented on ASTERIXDB-1683: -- What git version is this? It seems like somehow old config files are attempting to be used with a newer version or something like that. > About the test issues. > -- > > Key: ASTERIXDB-1683 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-1683 > Project: Apache AsterixDB > Issue Type: Bug > Components: Maven > Environment: MAC >Reporter: Wenhai > > Hi, all. I am really confusing about the junit tests. Even I have tried many > many ... times for mvn install/package again and again, the eclipse always > posed the following error. Who knows how can we handle this issue? > {noformat} > java.lang.NullPointerException > at java.util.Properties$LineReader.readLine(Properties.java:434) > at java.util.Properties.load0(Properties.java:353) > at java.util.Properties.load(Properties.java:341) > at > org.apache.asterix.common.config.AsterixPropertiesAccessor.loadAsterixBuildProperties(AsterixPropertiesAccessor.java:237) > at > org.apache.asterix.common.config.AsterixPropertiesAccessor.(AsterixPropertiesAccessor.java:132) > at > org.apache.asterix.common.config.AsterixPropertiesAccessor.getInstance(AsterixPropertiesAccessor.java:338) > at > org.apache.asterix.common.config.AsterixPropertiesAccessor.getInstance(AsterixPropertiesAccessor.java:347) > at > org.apache.asterix.api.common.AsterixHyracksIntegrationUtil.init(AsterixHyracksIntegrationUtil.java:67) > at > org.apache.asterix.test.optimizer.OptimizerTest.setUp(OptimizerTest.java:87) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:497) > at > org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) > at > org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) > at > org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) > at > org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24) > at > org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) > at org.junit.runners.ParentRunner.run(ParentRunner.java:363) > at > org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86) > at > org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) > java.lang.NullPointerException > at > org.apache.asterix.api.common.AsterixHyracksIntegrationUtil.deleteTransactionLogs(AsterixHyracksIntegrationUtil.java:212) > at > org.apache.asterix.api.common.AsterixHyracksIntegrationUtil.deinit(AsterixHyracksIntegrationUtil.java:191) > at > org.apache.asterix.test.optimizer.OptimizerTest.tearDown(OptimizerTest.java:104) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:497) > at > org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) > at > org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) > at > org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) > at > org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:33) > at org.junit.runners.ParentRunner.run(ParentRunner.java:363) > at > org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86) > at > org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) > at >
Change in asterixdb[master]: Make terminologies consistent in docs.
Yingyi Bu has uploaded a new change for review. https://asterix-gerrit.ics.uci.edu/1258 Change subject: Make terminologies consistent in docs. .. Make terminologies consistent in docs. Change-Id: I35a647601441a48bb5576b115324fb0dc6eae176 --- M asterixdb/asterix-doc/src/main/markdown/sqlpp/2_expr.md M asterixdb/asterix-doc/src/main/markdown/sqlpp/3_query.md M asterixdb/asterix-doc/src/main/markdown/sqlpp/5_ddl.md 3 files changed, 38 insertions(+), 21 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/58/1258/1 diff --git a/asterixdb/asterix-doc/src/main/markdown/sqlpp/2_expr.md b/asterixdb/asterix-doc/src/main/markdown/sqlpp/2_expr.md index 7641b92..484107e 100644 --- a/asterixdb/asterix-doc/src/main/markdown/sqlpp/2_expr.md +++ b/asterixdb/asterix-doc/src/main/markdown/sqlpp/2_expr.md @@ -31,7 +31,9 @@ | FunctionCallExpression | Constructor -The most basic building block for any SQL++ expression is PrimaryExpression. This can be a simple literal (constant) value, a reference to a query variable that is in scope, a parenthesized expression, a function call, or a newly constructed instance of the data model (such as a newly constructed record or list of data model instances). +The most basic building block for any SQL++ expression is PrimaryExpression. This can be a simple literal (constant) +value, a reference to a query variable that is in scope, a parenthesized expression, a function call, or a newly +constructed instance of the data model (such as a newly constructed record, array, or multiset of data model instances). ### Literals @@ -110,15 +112,25 @@ ### Constructors -ListConstructor ::= OrderedListConstructor | UnorderedListConstructor -OrderedListConstructor ::= "[" ( Expression ( "," Expression )* )? "]" -UnorderedListConstructor ::= "{{" ( Expression ( "," Expression )* )? "}}" +CollectionConstructor ::= ArrayConstructor | MultisetConstructor +ArrayConstructor ::= "[" ( Expression ( "," Expression )* )? "]" +MultisetConstructor ::= "{{" ( Expression ( "," Expression )* )? "}}" RecordConstructor::= "{" ( FieldBinding ( "," FieldBinding )* )? "}" FieldBinding ::= Expression ":" Expression -A major feature of SQL++ is its ability to construct new data model instances. This is accomplished using its constructors for each of the model's complex object structures, namely lists (ordered or unordered) and records. Ordered lists are like JSON arrays, while unordered lists have multiset (bag) semantics. Records are built from attributes that are field-name/field-value pairs, again like JSON. (See the data model document for more details on each.) +A major feature of SQL++ is its ability to construct new data model instances. This is accomplished using its constructors +for each of the model's complex object structures, namely arrays, multisets, and records. +Arrays are like JSON arrays, while multisets have bag semantics. +Records are built from fields that are field-name/field-value pairs, again like JSON. +(See the [data model document](../datamodel.html) for more details on each.) -The following examples illustrate how to construct a new ordered list with 3 items, a new record with 2 fields, and a new unordered list with 4 items, respectively. List elements can be homogeneous (as in the first example), which is the common case, or they may be heterogeneous (as in the third example). The data values and field name values used to construct lists and records in constructors are all simply SQL++ expressions. Thus, the list elements, field names, and field values used in constructors can be simple literals or they can come from query variable references or even arbitrarily complex SQL++ expressions (subqueries). +The following examples illustrate how to construct a new array with 3 items, a new record with 2 fields, +and a new multiset with 4 items, respectively. Array elements or multiset elements can be homogeneous (as in +the first example), +which is the common case, or they may be heterogeneous (as in the third example). The data values and field name values +used to construct arrays, multisets, and records in constructors are all simply SQL++ expressions. Thus, the collection elements, +field names, and field values used in constructors can be simple literals or they can come from query variable references +or even arbitrarily complex SQL++ expressions (subqueries). # Examples @@ -137,17 +149,22 @@ Field ::= "." Identifier Index ::= "[" ( Expression | "?" ) "]" -Components of complex types in the data model are accessed via path expressions. Path access can be applied to the result of a SQL++ expression that yields an instance of a complex type, e.g., a record or list instance. For records,
[jira] [Created] (ASTERIXDB-1683) About the test issues.
Wenhai created ASTERIXDB-1683: - Summary: About the test issues. Key: ASTERIXDB-1683 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1683 Project: Apache AsterixDB Issue Type: Bug Components: Maven Environment: MAC Reporter: Wenhai Hi, all. I am really confusing about the junit tests. Even I have tried many many ... times for mvn install/package again and again, the eclipse always posed the following error. Who knows how can we handle this issue? {noformat} java.lang.NullPointerException at java.util.Properties$LineReader.readLine(Properties.java:434) at java.util.Properties.load0(Properties.java:353) at java.util.Properties.load(Properties.java:341) at org.apache.asterix.common.config.AsterixPropertiesAccessor.loadAsterixBuildProperties(AsterixPropertiesAccessor.java:237) at org.apache.asterix.common.config.AsterixPropertiesAccessor.(AsterixPropertiesAccessor.java:132) at org.apache.asterix.common.config.AsterixPropertiesAccessor.getInstance(AsterixPropertiesAccessor.java:338) at org.apache.asterix.common.config.AsterixPropertiesAccessor.getInstance(AsterixPropertiesAccessor.java:347) at org.apache.asterix.api.common.AsterixHyracksIntegrationUtil.init(AsterixHyracksIntegrationUtil.java:67) at org.apache.asterix.test.optimizer.OptimizerTest.setUp(OptimizerTest.java:87) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) java.lang.NullPointerException at org.apache.asterix.api.common.AsterixHyracksIntegrationUtil.deleteTransactionLogs(AsterixHyracksIntegrationUtil.java:212) at org.apache.asterix.api.common.AsterixHyracksIntegrationUtil.deinit(AsterixHyracksIntegrationUtil.java:191) at org.apache.asterix.test.optimizer.OptimizerTest.tearDown(OptimizerTest.java:104) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:33) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) {nofomrat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (ASTERIXDB-1682) About the test issues.
Wenhai created ASTERIXDB-1682: - Summary: About the test issues. Key: ASTERIXDB-1682 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1682 Project: Apache AsterixDB Issue Type: Bug Components: Maven Environment: MAC Reporter: Wenhai Hi, all. I am really confusing about the junit tests. Even I have tried many many ... times for mvn install/package again and again, the eclipse always posed the following error. Who knows how can we handle this issue? {noformat} java.lang.NullPointerException at java.util.Properties$LineReader.readLine(Properties.java:434) at java.util.Properties.load0(Properties.java:353) at java.util.Properties.load(Properties.java:341) at org.apache.asterix.common.config.AsterixPropertiesAccessor.loadAsterixBuildProperties(AsterixPropertiesAccessor.java:237) at org.apache.asterix.common.config.AsterixPropertiesAccessor.(AsterixPropertiesAccessor.java:132) at org.apache.asterix.common.config.AsterixPropertiesAccessor.getInstance(AsterixPropertiesAccessor.java:338) at org.apache.asterix.common.config.AsterixPropertiesAccessor.getInstance(AsterixPropertiesAccessor.java:347) at org.apache.asterix.api.common.AsterixHyracksIntegrationUtil.init(AsterixHyracksIntegrationUtil.java:67) at org.apache.asterix.test.optimizer.OptimizerTest.setUp(OptimizerTest.java:87) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) java.lang.NullPointerException at org.apache.asterix.api.common.AsterixHyracksIntegrationUtil.deleteTransactionLogs(AsterixHyracksIntegrationUtil.java:212) at org.apache.asterix.api.common.AsterixHyracksIntegrationUtil.deinit(AsterixHyracksIntegrationUtil.java:191) at org.apache.asterix.test.optimizer.OptimizerTest.tearDown(OptimizerTest.java:104) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:33) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) {nofomrat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
Change in asterixdb[master]: Applied the multiway fuzzyjoin based on the prefix-based joi...
Jenkins has posted comments on this change. Change subject: Applied the multiway fuzzyjoin based on the prefix-based join and the selectFuzzyJoin testCases. .. Patch Set 17: WARNING: THIS CHANGE CONTAINS CROSS-PRODUCT CHANGES IN: * asterixdb * hyracks-fullstack PLEASE REVIEW CAREFULLY AND LOOK FOR API CHANGES! -- To view, visit https://asterix-gerrit.ics.uci.edu/1076 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: I8736f104905eeda763d39709e002c2b9629278cc Gerrit-PatchSet: 17 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Wenhai LiGerrit-Reviewer: Chen Li Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Taewoo Kim Gerrit-Reviewer: Wenhai Li Gerrit-HasComments: No
Change in asterixdb[master]: Add type check functions and their docs, including:
Jenkins has posted comments on this change. Change subject: Add type check functions and their docs, including: .. Patch Set 3: Integration-Tests+1 Integration Tests Successful https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-integration-tests/866/ : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/1257 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Id12067dbd89f74a6c1248eb7ac6504400a67cbf6 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Yingyi BuGerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: Applied the multiway fuzzyjoin based on the prefix-based joi...
Jenkins has posted comments on this change. Change subject: Applied the multiway fuzzyjoin based on the prefix-based join and the selectFuzzyJoin testCases. .. Patch Set 17: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-notopic/2946/ -- To view, visit https://asterix-gerrit.ics.uci.edu/1076 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: I8736f104905eeda763d39709e002c2b9629278cc Gerrit-PatchSet: 17 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Wenhai LiGerrit-Reviewer: Chen Li Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Taewoo Kim Gerrit-Reviewer: Wenhai Li Gerrit-HasComments: No
Change in asterixdb[master]: Add type check functions and their docs, including:
Jenkins has posted comments on this change. Change subject: Add type check functions and their docs, including: .. Patch Set 3: Integration Tests Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-integration-tests/866/ -- To view, visit https://asterix-gerrit.ics.uci.edu/1257 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Id12067dbd89f74a6c1248eb7ac6504400a67cbf6 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Yingyi BuGerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: ASTERIXDB-1608, ASTERIXDB-1617 Match user query for nonpure ...
Hello Michael Blow, Preston Carman, Jenkins, I'd like you to reexamine a change. Please visit https://asterix-gerrit.ics.uci.edu/1057 to look at the new patch set (#10). Change subject: ASTERIXDB-1608, ASTERIXDB-1617 Match user query for nonpure function calls .. ASTERIXDB-1608, ASTERIXDB-1617 Match user query for nonpure function calls This fix makes it so that nonpure functions are called in the same place and with the same number of executions as specified by the user in the query. This also means that indexes cannot be used for queries that compare with a nonpure call that is made on a per-record basis. Added optimizer tests Change-Id: I2dec322b30835625430c06acd7626d902bada137 --- M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/PushFieldAccessRule.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/AbstractIntroduceAccessMethodRule.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/AccessMethodUtils.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/BTreeAccessMethod.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/IAccessMethod.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/IOptimizableFuncExpr.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/IntroduceLSMComponentFilterRule.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/IntroduceSelectAccessMethodRule.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/InvertedIndexAccessMethod.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/OptimizableFuncExpr.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/OptimizableOperatorSubTree.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/RTreeAccessMethod.java A asterixdb/asterix-app/src/test/resources/optimizerts/queries/nonpure/global-datetime-no-index.aql A asterixdb/asterix-app/src/test/resources/optimizerts/queries/nonpure/global-datetime-use-index-return-time.aql A asterixdb/asterix-app/src/test/resources/optimizerts/queries/nonpure/global-datetime-use-index.aql A asterixdb/asterix-app/src/test/resources/optimizerts/queries/nonpure/keep-datetime-local.aql A asterixdb/asterix-app/src/test/resources/optimizerts/queries/nonpure/local-datetime-ignore-index.aql A asterixdb/asterix-app/src/test/resources/optimizerts/queries/nonpure/local-datetime-no-index.aql A asterixdb/asterix-app/src/test/resources/optimizerts/queries/nonpure/maintain-nonpure-location-in-join-cannot-index.aql A asterixdb/asterix-app/src/test/resources/optimizerts/queries/nonpure/query-ASTERIXDB-1608.aql M asterixdb/asterix-app/src/test/resources/optimizerts/results/btree-index/btree-datetime-02.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results/nonpure/global-datetime-no-index.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results/nonpure/global-datetime-use-index-return-time.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results/nonpure/global-datetime-use-index.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results/nonpure/keep-datetime-local.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results/nonpure/local-datetime-ignore-index.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results/nonpure/local-datetime-no-index.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results/nonpure/maintain-nonpure-location-in-join-cannot-index.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results/nonpure/query-ASTERIXDB-1608.plan M asterixdb/asterix-app/src/test/resources/optimizerts/results/query_issue849.plan M hyracks-fullstack/algebricks/algebricks-core/src/main/java/org/apache/hyracks/algebricks/core/algebra/util/OperatorManipulationUtil.java M hyracks-fullstack/algebricks/algebricks-core/src/main/java/org/apache/hyracks/algebricks/core/algebra/util/OperatorPropertiesUtil.java M hyracks-fullstack/algebricks/algebricks-rewriter/src/main/java/org/apache/hyracks/algebricks/rewriter/rules/ConsolidateAssignsRule.java M hyracks-fullstack/algebricks/algebricks-rewriter/src/main/java/org/apache/hyracks/algebricks/rewriter/rules/EnforceStructuralPropertiesRule.java M hyracks-fullstack/algebricks/algebricks-rewriter/src/main/java/org/apache/hyracks/algebricks/rewriter/rules/ExtractCommonExpressionsRule.java M hyracks-fullstack/algebricks/algebricks-rewriter/src/main/java/org/apache/hyracks/algebricks/rewriter/rules/InlineVariablesRule.java M hyracks-fullstack/algebricks/algebricks-rewriter/src/main/java/org/apache/hyracks/algebricks/rewriter/rules/PushMapOperatorDownThroughProductRule.java M
Change in asterixdb[master]: ASTERIXDB-1608, ASTERIXDB-1617 Match user query for nonpure ...
Jenkins has posted comments on this change. Change subject: ASTERIXDB-1608, ASTERIXDB-1617 Match user query for nonpure function calls .. Patch Set 10: WARNING: THIS CHANGE CONTAINS CROSS-PRODUCT CHANGES IN: * asterixdb * hyracks-fullstack PLEASE REVIEW CAREFULLY AND LOOK FOR API CHANGES! -- To view, visit https://asterix-gerrit.ics.uci.edu/1057 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: I2dec322b30835625430c06acd7626d902bada137 Gerrit-PatchSet: 10 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Steven JacobsGerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Blow Gerrit-Reviewer: Preston Carman Gerrit-Reviewer: Steven Jacobs Gerrit-Reviewer: Taewoo Kim Gerrit-Reviewer: Yingyi Bu Gerrit-HasComments: No
Change in asterixdb[master]: Add type check functions and their docs, including:
Hello Jenkins, I'd like you to reexamine a change. Please visit https://asterix-gerrit.ics.uci.edu/1257 to look at the new patch set (#3). Change subject: Add type check functions and their docs, including: .. Add type check functions and their docs, including: -isboolean (isbool) -isnumber (isnum) -isstring (istr) -isarray -isobject (isobj) Change-Id: Id12067dbd89f74a6c1248eb7ac6504400a67cbf6 --- M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/translator/util/FunctionCollection.java D asterixdb/asterix-app/rttest/results/temporal/interval_joins/interval_overlapping/interval_overlapping.3.adm D asterixdb/asterix-app/rttest/results/temporal/interval_joins/interval_overlapping/interval_overlapping.4.adm A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isarray/isarray.1.query.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isboolean/isboolean.1.query.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isnumber/isnumber.1.query.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isobject/isobject.1.query.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isstring/isstring.1.query.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/results/types/isarray/isarray.1.adm A asterixdb/asterix-app/src/test/resources/runtimets/results/types/isboolean/isboolean.1.adm A asterixdb/asterix-app/src/test/resources/runtimets/results/types/isnumber/isnumber.1.adm A asterixdb/asterix-app/src/test/resources/runtimets/results/types/isobject/isobject.1.adm A asterixdb/asterix-app/src/test/resources/runtimets/results/types/isstring/isstring.1.adm M asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml M asterixdb/asterix-doc/pom.xml M asterixdb/asterix-doc/src/main/markdown/builtins/0_toc.md A asterixdb/asterix-doc/src/main/markdown/builtins/11_type.md R asterixdb/asterix-doc/src/main/markdown/builtins/12_misc.md M asterixdb/asterix-lang-common/src/main/java/org/apache/asterix/lang/common/util/CommonFunctionMapUtil.java M asterixdb/asterix-om/src/main/java/org/apache/asterix/om/functions/AsterixBuiltinFunctions.java A asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/functions/IsArrayDescriptor.java A asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/functions/IsBooleanDescriptor.java A asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/functions/IsNumberDescriptor.java A asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/functions/IsObjectDescriptor.java A asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/functions/IsStringDescriptor.java 25 files changed, 835 insertions(+), 138 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/57/1257/3 -- To view, visit https://asterix-gerrit.ics.uci.edu/1257 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: newpatchset Gerrit-Change-Id: Id12067dbd89f74a6c1248eb7ac6504400a67cbf6 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Yingyi BuGerrit-Reviewer: Jenkins
Change in asterixdb[master]: Add type check functions, including:
Hello Jenkins, I'd like you to reexamine a change. Please visit https://asterix-gerrit.ics.uci.edu/1257 to look at the new patch set (#2). Change subject: Add type check functions, including: .. Add type check functions, including: -isboolean -isnumber -isstring -isarray -isobject Change-Id: Id12067dbd89f74a6c1248eb7ac6504400a67cbf6 --- M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/translator/util/FunctionCollection.java D asterixdb/asterix-app/rttest/results/temporal/interval_joins/interval_overlapping/interval_overlapping.3.adm D asterixdb/asterix-app/rttest/results/temporal/interval_joins/interval_overlapping/interval_overlapping.4.adm A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isarray/isarray.1.query.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isboolean/isboolean.1.query.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isnumber/isnumber.1.query.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isobject/isobject.1.query.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isstring/isstring.1.query.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/results/types/isarray/isarray.1.adm A asterixdb/asterix-app/src/test/resources/runtimets/results/types/isboolean/isboolean.1.adm A asterixdb/asterix-app/src/test/resources/runtimets/results/types/isnumber/isnumber.1.adm A asterixdb/asterix-app/src/test/resources/runtimets/results/types/isobject/isobject.1.adm A asterixdb/asterix-app/src/test/resources/runtimets/results/types/isstring/isstring.1.adm M asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml M asterixdb/asterix-doc/pom.xml M asterixdb/asterix-doc/src/main/markdown/builtins/0_toc.md A asterixdb/asterix-doc/src/main/markdown/builtins/11_type.md R asterixdb/asterix-doc/src/main/markdown/builtins/12_misc.md M asterixdb/asterix-lang-common/src/main/java/org/apache/asterix/lang/common/util/CommonFunctionMapUtil.java M asterixdb/asterix-om/src/main/java/org/apache/asterix/om/functions/AsterixBuiltinFunctions.java A asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/functions/IsArrayDescriptor.java A asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/functions/IsBooleanDescriptor.java A asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/functions/IsNumberDescriptor.java A asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/functions/IsObjectDescriptor.java A asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/functions/IsStringDescriptor.java 25 files changed, 831 insertions(+), 138 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/57/1257/2 -- To view, visit https://asterix-gerrit.ics.uci.edu/1257 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: newpatchset Gerrit-Change-Id: Id12067dbd89f74a6c1248eb7ac6504400a67cbf6 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Yingyi BuGerrit-Reviewer: Jenkins
Change in asterixdb[master]: Add type check functions, including:
Jenkins has posted comments on this change. Change subject: Add type check functions, including: .. Patch Set 1: Integration-Tests+1 Integration Tests Successful https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-integration-tests/865/ : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/1257 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Id12067dbd89f74a6c1248eb7ac6504400a67cbf6 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Yingyi BuGerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: Add type check functions, including:
Jenkins has posted comments on this change. Change subject: Add type check functions, including: .. Patch Set 1: Integration Tests Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-integration-tests/865/ -- To view, visit https://asterix-gerrit.ics.uci.edu/1257 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Id12067dbd89f74a6c1248eb7ac6504400a67cbf6 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Yingyi BuGerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: Add type check functions, including:
Yingyi Bu has uploaded a new change for review. https://asterix-gerrit.ics.uci.edu/1257 Change subject: Add type check functions, including: .. Add type check functions, including: -isboolean -isnumber -isstring -isarray -isobject Change-Id: Id12067dbd89f74a6c1248eb7ac6504400a67cbf6 --- M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/translator/util/FunctionCollection.java A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isarray/isarray.1.query.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isboolean/isboolean.1.query.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isnumber/isnumber.1.query.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isobject/isobject.1.query.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isstring/isstring.1.query.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/results/types/isarray/isarray.1.adm A asterixdb/asterix-app/src/test/resources/runtimets/results/types/isboolean/isboolean.1.adm A asterixdb/asterix-app/src/test/resources/runtimets/results/types/isnumber/isnumber.1.adm A asterixdb/asterix-app/src/test/resources/runtimets/results/types/isobject/isobject.1.adm A asterixdb/asterix-app/src/test/resources/runtimets/results/types/isstring/isstring.1.adm M asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml M asterixdb/asterix-lang-common/src/main/java/org/apache/asterix/lang/common/util/CommonFunctionMapUtil.java M asterixdb/asterix-om/src/main/java/org/apache/asterix/om/functions/AsterixBuiltinFunctions.java A asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/functions/IsArrayDescriptor.java A asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/functions/IsBooleanDescriptor.java A asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/functions/IsNumberDescriptor.java A asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/functions/IsObjectDescriptor.java A asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/functions/IsStringDescriptor.java 19 files changed, 556 insertions(+), 0 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/57/1257/1 diff --git a/asterixdb/asterix-algebra/src/main/java/org/apache/asterix/translator/util/FunctionCollection.java b/asterixdb/asterix-algebra/src/main/java/org/apache/asterix/translator/util/FunctionCollection.java index 2482121..dd45c86 100644 --- a/asterixdb/asterix-algebra/src/main/java/org/apache/asterix/translator/util/FunctionCollection.java +++ b/asterixdb/asterix-algebra/src/main/java/org/apache/asterix/translator/util/FunctionCollection.java @@ -157,8 +157,13 @@ import org.apache.asterix.runtime.evaluators.functions.HashedGramTokensDescriptor; import org.apache.asterix.runtime.evaluators.functions.HashedWordTokensDescriptor; import org.apache.asterix.runtime.evaluators.functions.InjectFailureDescriptor; +import org.apache.asterix.runtime.evaluators.functions.IsArrayDescriptor; +import org.apache.asterix.runtime.evaluators.functions.IsBooleanDescriptor; import org.apache.asterix.runtime.evaluators.functions.IsMissingDescriptor; import org.apache.asterix.runtime.evaluators.functions.IsNullDescriptor; +import org.apache.asterix.runtime.evaluators.functions.IsNumberDescriptor; +import org.apache.asterix.runtime.evaluators.functions.IsObjectDescriptor; +import org.apache.asterix.runtime.evaluators.functions.IsStringDescriptor; import org.apache.asterix.runtime.evaluators.functions.IsSystemNullDescriptor; import org.apache.asterix.runtime.evaluators.functions.IsUnknownDescriptor; import org.apache.asterix.runtime.evaluators.functions.LenDescriptor; @@ -666,6 +671,13 @@ functionsToInjectUnkownHandling.add(GetOverlappingIntervalDescriptor.FACTORY); functionsToInjectUnkownHandling.add(DurationFromIntervalDescriptor.FACTORY); +// Type functions. +functionsToInjectUnkownHandling.add(IsBooleanDescriptor.FACTORY); +functionsToInjectUnkownHandling.add(IsNumberDescriptor.FACTORY); +functionsToInjectUnkownHandling.add(IsStringDescriptor.FACTORY); +functionsToInjectUnkownHandling.add(IsArrayDescriptor.FACTORY); +functionsToInjectUnkownHandling.add(IsObjectDescriptor.FACTORY); + // Cast function functionsToInjectUnkownHandling.add(CastTypeDescriptor.FACTORY); diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isarray/isarray.1.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/types/isarray/isarray.1.query.sqlpp new file mode 100644 index 000..4ea86f7 --- /dev/null +++
[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=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)