[jira] [Commented] (ASTERIXDB-1529) Query 7 in AsterixDB 101 is broken

2016-08-10 Thread ASF subversion and git services (JIRA) 

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

ASF subversion and git services commented on ASTERIXDB-1529:


Commit dcd9112fa71689c015a525adcdbe3ce78c79f17f in asterixdb's branch 
refs/heads/master from [~buyingyi]
[ https://git-wip-us.apache.org/repos/asf?p=asterixdb.git;h=dcd9112 ]

ASTERIXDB-1529: remove "not" from reserved keywords in AQL.

Change-Id: Ib79fee208acc7ae28f8e082eebb26ed728b39723
Reviewed-on: https://asterix-gerrit.ics.uci.edu/1062
Sonar-Qube: Jenkins 
Tested-by: Jenkins 
Integration-Tests: Jenkins 
Reviewed-by: Till Westmann 


> Query 7 in AsterixDB 101 is broken
> --
>
> Key: ASTERIXDB-1529
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1529
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: Documentation
> Environment: Latest binary download from Apache AsterixDB site 
> (master)
>Reporter: Michael J. Carey
>Assignee: Yingyi Bu
>
> Query 7 in the 101 tutorial is:
> use dataverse TinySocial;
> from $fbu in dataset FacebookUsers
> where (every $e in $fbu.employment satisfies not(is-null($e.end-date)))
> select $fbu;
> This query no longer works at all - instead it gives a syntax error:
> Error: Encountered " "not" "not "" at line 4, column 50.
> Was expecting one of:
> "dataset" ...
> "every" ...
> "for" ...
> "from" ...
> "if" ...
> "let" ...
> "some" ...
> "with" ...
> "-" ...
> "+" ...
> "(" ...
> "[" ...
> "{" ...
> "{{" ...
>  ...
> "missing" ...
> "null" ...
> "true" ...
> "false" ...
>  ...
>  ...
>  ...
>  ...
>  ...
> 
> ==> where (every $e in $fbu.employment satisfies 
> not(is-null($e.end-date)))



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

[jira] [Commented] (ASTERIXDB-1529) Query 7 in AsterixDB 101 is broken

2016-07-14 Thread Till Westmann (JIRA) 

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

Till Westmann commented on ASTERIXDB-1529:
--

Yes, that's one option (but we'd need to implement that in maven). Another 
option that I looked at today (but failed to get working so far) could be to 
use doxia macros as the maven site plugin uses doxia ...

> Query 7 in AsterixDB 101 is broken
> --
>
> Key: ASTERIXDB-1529
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1529
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: Documentation
> Environment: Latest binary download from Apache AsterixDB site 
> (master)
>Reporter: Michael J. Carey
>Assignee: Yingyi Bu
>
> Query 7 in the 101 tutorial is:
> use dataverse TinySocial;
> from $fbu in dataset FacebookUsers
> where (every $e in $fbu.employment satisfies not(is-null($e.end-date)))
> select $fbu;
> This query no longer works at all - instead it gives a syntax error:
> Error: Encountered " "not" "not "" at line 4, column 50.
> Was expecting one of:
> "dataset" ...
> "every" ...
> "for" ...
> "from" ...
> "if" ...
> "let" ...
> "some" ...
> "with" ...
> "-" ...
> "+" ...
> "(" ...
> "[" ...
> "{" ...
> "{{" ...
>  ...
> "missing" ...
> "null" ...
> "true" ...
> "false" ...
>  ...
>  ...
>  ...
>  ...
>  ...
> 
> ==> where (every $e in $fbu.employment satisfies 
> not(is-null($e.end-date)))



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

[jira] [Commented] (ASTERIXDB-1529) Query 7 in AsterixDB 101 is broken

2016-07-14 Thread Taewoo Kim (JIRA) 

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

Taewoo Kim commented on ASTERIXDB-1529:
---

Got it. Thanks!

> Query 7 in AsterixDB 101 is broken
> --
>
> Key: ASTERIXDB-1529
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1529
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: Documentation
> Environment: Latest binary download from Apache AsterixDB site 
> (master)
>Reporter: Michael J. Carey
>Assignee: Yingyi Bu
>
> Query 7 in the 101 tutorial is:
> use dataverse TinySocial;
> from $fbu in dataset FacebookUsers
> where (every $e in $fbu.employment satisfies not(is-null($e.end-date)))
> select $fbu;
> This query no longer works at all - instead it gives a syntax error:
> Error: Encountered " "not" "not "" at line 4, column 50.
> Was expecting one of:
> "dataset" ...
> "every" ...
> "for" ...
> "from" ...
> "if" ...
> "let" ...
> "some" ...
> "with" ...
> "-" ...
> "+" ...
> "(" ...
> "[" ...
> "{" ...
> "{{" ...
>  ...
> "missing" ...
> "null" ...
> "true" ...
> "false" ...
>  ...
>  ...
>  ...
>  ...
>  ...
> 
> ==> where (every $e in $fbu.employment satisfies 
> not(is-null($e.end-date)))



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

[jira] [Commented] (ASTERIXDB-1529) Query 7 in AsterixDB 101 is broken

2016-07-14 Thread Taewoo Kim (JIRA) 

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

Taewoo Kim commented on ASTERIXDB-1529:
---

Got it. Thanks!

> Query 7 in AsterixDB 101 is broken
> --
>
> Key: ASTERIXDB-1529
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1529
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: Documentation
> Environment: Latest binary download from Apache AsterixDB site 
> (master)
>Reporter: Michael J. Carey
>Assignee: Yingyi Bu
>
> Query 7 in the 101 tutorial is:
> use dataverse TinySocial;
> from $fbu in dataset FacebookUsers
> where (every $e in $fbu.employment satisfies not(is-null($e.end-date)))
> select $fbu;
> This query no longer works at all - instead it gives a syntax error:
> Error: Encountered " "not" "not "" at line 4, column 50.
> Was expecting one of:
> "dataset" ...
> "every" ...
> "for" ...
> "from" ...
> "if" ...
> "let" ...
> "some" ...
> "with" ...
> "-" ...
> "+" ...
> "(" ...
> "[" ...
> "{" ...
> "{{" ...
>  ...
> "missing" ...
> "null" ...
> "true" ...
> "false" ...
>  ...
>  ...
>  ...
>  ...
>  ...
> 
> ==> where (every $e in $fbu.employment satisfies 
> not(is-null($e.end-date)))



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

[jira] [Commented] (ASTERIXDB-1529) Query 7 in AsterixDB 101 is broken

2016-07-14 Thread Yingyi Bu (JIRA) 

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

Yingyi Bu commented on ASTERIXDB-1529:
--

Taewoo,

The examples should already be part of the runtime tests:
asterixdb/asterix-app/src/test/resources/runtimets/queries/tinysocial
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial

The problem is that when we updated those test queries, we didn't realize that 
they are part of the 101 doc.

Best,
Yingyi

> Query 7 in AsterixDB 101 is broken
> --
>
> Key: ASTERIXDB-1529
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1529
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: Documentation
> Environment: Latest binary download from Apache AsterixDB site 
> (master)
>Reporter: Michael J. Carey
>Assignee: Yingyi Bu
>
> Query 7 in the 101 tutorial is:
> use dataverse TinySocial;
> from $fbu in dataset FacebookUsers
> where (every $e in $fbu.employment satisfies not(is-null($e.end-date)))
> select $fbu;
> This query no longer works at all - instead it gives a syntax error:
> Error: Encountered " "not" "not "" at line 4, column 50.
> Was expecting one of:
> "dataset" ...
> "every" ...
> "for" ...
> "from" ...
> "if" ...
> "let" ...
> "some" ...
> "with" ...
> "-" ...
> "+" ...
> "(" ...
> "[" ...
> "{" ...
> "{{" ...
>  ...
> "missing" ...
> "null" ...
> "true" ...
> "false" ...
>  ...
>  ...
>  ...
>  ...
>  ...
> 
> ==> where (every $e in $fbu.employment satisfies 
> not(is-null($e.end-date)))



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

[jira] [Commented] (ASTERIXDB-1529) Query 7 in AsterixDB 101 is broken

2016-07-14 Thread Taewoo Kim (JIRA) 

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

Taewoo Kim commented on ASTERIXDB-1529:
---

In addition, we can add ADM 101 examples as the runtime execution test cases so 
that no inconsistency would happen. 

> Query 7 in AsterixDB 101 is broken
> --
>
> Key: ASTERIXDB-1529
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1529
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: Documentation
> Environment: Latest binary download from Apache AsterixDB site 
> (master)
>Reporter: Michael J. Carey
>Assignee: Yingyi Bu
>
> Query 7 in the 101 tutorial is:
> use dataverse TinySocial;
> from $fbu in dataset FacebookUsers
> where (every $e in $fbu.employment satisfies not(is-null($e.end-date)))
> select $fbu;
> This query no longer works at all - instead it gives a syntax error:
> Error: Encountered " "not" "not "" at line 4, column 50.
> Was expecting one of:
> "dataset" ...
> "every" ...
> "for" ...
> "from" ...
> "if" ...
> "let" ...
> "some" ...
> "with" ...
> "-" ...
> "+" ...
> "(" ...
> "[" ...
> "{" ...
> "{{" ...
>  ...
> "missing" ...
> "null" ...
> "true" ...
> "false" ...
>  ...
>  ...
>  ...
>  ...
>  ...
> 
> ==> where (every $e in $fbu.employment satisfies 
> not(is-null($e.end-date)))



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

[jira] [Commented] (ASTERIXDB-1529) Query 7 in AsterixDB 101 is broken

2016-07-14 Thread Michael J. Carey (JIRA) 

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

Michael J. Carey commented on ASTERIXDB-1529:
-

Ah - indeed!  Note to selves: We need to update the AQL reference manual as 
well (to expand on missing info now).

> Query 7 in AsterixDB 101 is broken
> --
>
> Key: ASTERIXDB-1529
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1529
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: Documentation
> Environment: Latest binary download from Apache AsterixDB site 
> (master)
>Reporter: Michael J. Carey
>Assignee: Yingyi Bu
>
> Query 7 in the 101 tutorial is:
> use dataverse TinySocial;
> from $fbu in dataset FacebookUsers
> where (every $e in $fbu.employment satisfies not(is-null($e.end-date)))
> select $fbu;
> This query no longer works at all - instead it gives a syntax error:
> Error: Encountered " "not" "not "" at line 4, column 50.
> Was expecting one of:
> "dataset" ...
> "every" ...
> "for" ...
> "from" ...
> "if" ...
> "let" ...
> "some" ...
> "with" ...
> "-" ...
> "+" ...
> "(" ...
> "[" ...
> "{" ...
> "{{" ...
>  ...
> "missing" ...
> "null" ...
> "true" ...
> "false" ...
>  ...
>  ...
>  ...
>  ...
>  ...
> 
> ==> where (every $e in $fbu.employment satisfies 
> not(is-null($e.end-date)))



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

[jira] [Commented] (ASTERIXDB-1529) Query 7 in AsterixDB 101 is broken

2016-07-14 Thread Yingyi Bu (JIRA) 

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

Yingyi Bu commented on ASTERIXDB-1529:
--

I think in the input data, the field "end-date" is missing, and that's 
different from null :-)

> Query 7 in AsterixDB 101 is broken
> --
>
> Key: ASTERIXDB-1529
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1529
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: Documentation
> Environment: Latest binary download from Apache AsterixDB site 
> (master)
>Reporter: Michael J. Carey
>Assignee: Yingyi Bu
>
> Query 7 in the 101 tutorial is:
> use dataverse TinySocial;
> from $fbu in dataset FacebookUsers
> where (every $e in $fbu.employment satisfies not(is-null($e.end-date)))
> select $fbu;
> This query no longer works at all - instead it gives a syntax error:
> Error: Encountered " "not" "not "" at line 4, column 50.
> Was expecting one of:
> "dataset" ...
> "every" ...
> "for" ...
> "from" ...
> "if" ...
> "let" ...
> "some" ...
> "with" ...
> "-" ...
> "+" ...
> "(" ...
> "[" ...
> "{" ...
> "{{" ...
>  ...
> "missing" ...
> "null" ...
> "true" ...
> "false" ...
>  ...
>  ...
>  ...
>  ...
>  ...
> 
> ==> where (every $e in $fbu.employment satisfies 
> not(is-null($e.end-date)))



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

[jira] [Commented] (ASTERIXDB-1529) Query 7 in AsterixDB 101 is broken

2016-07-14 Thread Yingyi Bu (JIRA) 

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

Yingyi Bu commented on ASTERIXDB-1529:
--

"not" is used in DDLs, for example:
create dataverse TinySocial if not exists;

Previously, there was a hack in the AQL parser that treats "not exists" as a 
whole. 
Therefore, it didn't work if someone put more spaces between "not" and 
"exists".  Abdullah just fixed that a day ago.


> Query 7 in AsterixDB 101 is broken
> --
>
> Key: ASTERIXDB-1529
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1529
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: Documentation
> Environment: Latest binary download from Apache AsterixDB site 
> (master)
>Reporter: Michael J. Carey
>Assignee: Yingyi Bu
>
> Query 7 in the 101 tutorial is:
> use dataverse TinySocial;
> from $fbu in dataset FacebookUsers
> where (every $e in $fbu.employment satisfies not(is-null($e.end-date)))
> select $fbu;
> This query no longer works at all - instead it gives a syntax error:
> Error: Encountered " "not" "not "" at line 4, column 50.
> Was expecting one of:
> "dataset" ...
> "every" ...
> "for" ...
> "from" ...
> "if" ...
> "let" ...
> "some" ...
> "with" ...
> "-" ...
> "+" ...
> "(" ...
> "[" ...
> "{" ...
> "{{" ...
>  ...
> "missing" ...
> "null" ...
> "true" ...
> "false" ...
>  ...
>  ...
>  ...
>  ...
>  ...
> 
> ==> where (every $e in $fbu.employment satisfies 
> not(is-null($e.end-date)))



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

[jira] [Commented] (ASTERIXDB-1529) Query 7 in AsterixDB 101 is broken

2016-07-14 Thread Michael J. Carey (JIRA) 

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

Michael J. Carey commented on ASTERIXDB-1529:
-

PS: But is-null should also still work - no? (I thought null, missing, and the 
generalization unknown were all supported?)

> Query 7 in AsterixDB 101 is broken
> --
>
> Key: ASTERIXDB-1529
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1529
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: Documentation
> Environment: Latest binary download from Apache AsterixDB site 
> (master)
>Reporter: Michael J. Carey
>Assignee: Yingyi Bu
>
> Query 7 in the 101 tutorial is:
> use dataverse TinySocial;
> from $fbu in dataset FacebookUsers
> where (every $e in $fbu.employment satisfies not(is-null($e.end-date)))
> select $fbu;
> This query no longer works at all - instead it gives a syntax error:
> Error: Encountered " "not" "not "" at line 4, column 50.
> Was expecting one of:
> "dataset" ...
> "every" ...
> "for" ...
> "from" ...
> "if" ...
> "let" ...
> "some" ...
> "with" ...
> "-" ...
> "+" ...
> "(" ...
> "[" ...
> "{" ...
> "{{" ...
>  ...
> "missing" ...
> "null" ...
> "true" ...
> "false" ...
>  ...
>  ...
>  ...
>  ...
>  ...
> 
> ==> where (every $e in $fbu.employment satisfies 
> not(is-null($e.end-date)))



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

[jira] [Commented] (ASTERIXDB-1529) Query 7 in AsterixDB 101 is broken

2016-07-14 Thread Michael J. Carey (JIRA) 

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

Michael J. Carey commented on ASTERIXDB-1529:
-

Where else does "not" appear - i.e., why (in AQL) would be be reserved now but 
not have been before?

> Query 7 in AsterixDB 101 is broken
> --
>
> Key: ASTERIXDB-1529
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1529
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: Documentation
> Environment: Latest binary download from Apache AsterixDB site 
> (master)
>Reporter: Michael J. Carey
>Assignee: Yingyi Bu
>
> Query 7 in the 101 tutorial is:
> use dataverse TinySocial;
> from $fbu in dataset FacebookUsers
> where (every $e in $fbu.employment satisfies not(is-null($e.end-date)))
> select $fbu;
> This query no longer works at all - instead it gives a syntax error:
> Error: Encountered " "not" "not "" at line 4, column 50.
> Was expecting one of:
> "dataset" ...
> "every" ...
> "for" ...
> "from" ...
> "if" ...
> "let" ...
> "some" ...
> "with" ...
> "-" ...
> "+" ...
> "(" ...
> "[" ...
> "{" ...
> "{{" ...
>  ...
> "missing" ...
> "null" ...
> "true" ...
> "false" ...
>  ...
>  ...
>  ...
>  ...
>  ...
> 
> ==> where (every $e in $fbu.employment satisfies 
> not(is-null($e.end-date)))



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

[jira] [Commented] (ASTERIXDB-1529) Query 7 in AsterixDB 101 is broken

2016-07-14 Thread Yingyi Bu (JIRA) 

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

Yingyi Bu commented on ASTERIXDB-1529:
--

Mike,
  
   1. "not" is a reserved keyword,  thus not->"not";
   2. since we added MISSING,  is-null -> is-unknown.

Best,
Yingyi

> Query 7 in AsterixDB 101 is broken
> --
>
> Key: ASTERIXDB-1529
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1529
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: Documentation
> Environment: Latest binary download from Apache AsterixDB site 
> (master)
>Reporter: Michael J. Carey
>Assignee: Yingyi Bu
>
> Query 7 in the 101 tutorial is:
> use dataverse TinySocial;
> from $fbu in dataset FacebookUsers
> where (every $e in $fbu.employment satisfies not(is-null($e.end-date)))
> select $fbu;
> This query no longer works at all - instead it gives a syntax error:
> Error: Encountered " "not" "not "" at line 4, column 50.
> Was expecting one of:
> "dataset" ...
> "every" ...
> "for" ...
> "from" ...
> "if" ...
> "let" ...
> "some" ...
> "with" ...
> "-" ...
> "+" ...
> "(" ...
> "[" ...
> "{" ...
> "{{" ...
>  ...
> "missing" ...
> "null" ...
> "true" ...
> "false" ...
>  ...
>  ...
>  ...
>  ...
>  ...
> 
> ==> where (every $e in $fbu.employment satisfies 
> not(is-null($e.end-date)))



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