Details
Description
Following query gives error for cbas:
|
|
SELECT DISTINCT( varchar_field1 ) FROM CouchbaseAnalytics.simple_table_shadow WHERE ( ( ( decimal_field1 BETWEEN 2 and 9997 ) ) OR ( ( ( ( ( int_field1 IN [ 8 , 27 , 41 , 42 , 65 ] ) OR ( decimal_field1 = TRUNC( 1000 * RADIANS( 5076 ), 0 ) ) ) ) OR ( ( ( MILLIS( datetime_field1 ) = MILLIS( DATE_ADD_STR('2007-05-16 00:00:00',-1,'hour') ) ) ) OR ( ( NOT ( bool_field1 ) ) ) ) ) AND ( ( ( decimal_field1 BETWEEN 2 and 9997 ) AND ( decimal_field1 < ( 5076 % 2 ) ) ) ) ) ) AND ( ( NOT ( ( char_field1 = "N" ) ) ) OR ( ( ( MILLIS( datetime_field1 ) >= MILLIS( DATE_ADD_STR('2007-05-16 00:00:00',-1,'day') ) ) ) AND ( ( MILLIS( datetime_field1 ) IN [ MILLIS( '1999-01-12 00:00:00' ) ,MILLIS( '1999-01-24 00:00:00' ) ,MILLIS( '1999-02-01 00:00:00' ) ,MILLIS( '1999-02-06 00:00:00' ) ,MILLIS( '1999-02-09 00:00:00' ) ] ) ) ) ) OR ( ( NOT ( primary_key_id >= "549" ) ) ) AND ( ( ( MILLIS( datetime_field1 ) > MILLIS( '2007-05-16 00:00:00' ) ) ) AND ( NOT ( ( MILLIS( datetime_field1 ) <= MILLIS( DATE_ADD_STR('2007-05-16 00:00:00',1,'hour') ) ) ) ) ) ;
|
|
Error reported:
|
"msg": "org.apache.asterix.common.exceptions.AsterixException: function CouchbaseAnalytics.MILLIS@1 is undefined "
|
|
Above query works well in n1ql.
|