Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-20960

[CX] function CouchbaseAnalytics.MILLIS@1 is undefined

    XMLWordPrintable

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.
      

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            dmitry.lychagin Dmitry Lychagin (Inactive)
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty