[DRILL-2115] Disable function CARDINALITY in grammar

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 0.9.0
• Component/s: Query Planning & Optimization
• Labels: error_message_must_fix no_verified_test
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Victoria Markman
• Created: 29/Jan/15 18:24
• Updated: 29/Apr/15 00:07
• Resolved: 08/Feb/15 03:35

Description

Since we don't support multiset type, we should disable CARDINALITY function as well:

0: jdbc:drill:schema=dfs> select cardinality(list) from `test.json`;
Query failed: Query stopped., Failure while trying to materialize incoming schema.  Errors:
 
Error in expression at index -1.  Error: Missing function implementation: [cardinality(BIGINT-REPEATED)].  Full expression: --UNKNOWN EXPRESSION--.. [ db86cf79-6083-4ad7-afa1-fac534b942bc on atsqa4-134.qa.lab:31010 ]


Error: exception while executing query: Failure while executing query. (state=,code=0)
0: jdbc:drill:schema=dfs> select cardinality(id) from `test.json`;
Query failed: Query stopped., Failure while trying to materialize incoming schema.  Errors:
 
Error in expression at index -1.  Error: Missing function implementation: [cardinality(BIGINT-OPTIONAL)].  Full expression: --UNKNOWN EXPRESSION--.. [ 1f209cb2-4d60-4c1d-b1d0-d921f8e8a913 on atsqa4-134.qa.lab:31010 ]


Error: exception while executing query: Failure while executing query. (state=,code=0)
0: jdbc:drill:schema=dfs> select cardinality() from `test.json`;
Query failed: SqlValidatorException: Invalid number of arguments to function 'CARDINALITY'. Was expecting 1 arguments

Error: exception while executing query: Failure while executing query. (state=,code=0)
0: jdbc:drill:schema=dfs> select cardinality('aa') from `test.json`;
Query failed: SqlValidatorException: Cannot apply 'CARDINALITY' to arguments of type 'CARDINALITY(<CHAR(2)>)'. Supported form(s): 'CARDINALITY(<MULTISET>)'
'CARDINALITY(<ARRAY>)'
'CARDINALITY(<MAP>)'

Error: exception while executing query: Failure while executing query. (state=,code=0)

Issue Links

• depends upon: DRILL-1921 Throw unsupported error message some set operators that are not currently supported
• is duplicated by: DRILL-1921 Throw unsupported error message some set operators that are not currently supported