When I am doing sorting on event time column I am getting below error:
An error occurred while executing query: exception encountered while executing external function 'internal:navigation-query', caused by error endeca-err:MDEX0001 : Invalid input : Error in EQL Query: - In statement "_$Records_1385576435829": In ORDER BY clause: ORDER BY clauses may refer only to attributes defined in the same statement; "EVENT_TIMEYEAR" is not
I am not sure what this error is.What should be done to remove this or should I remove sorting on this column?
Please see this doc about Order By.
In it, in the section "Expression sorting", it is stated:
"The expressions in the ORDER BY clause will only be able to refer to attributes of the local statement, except through lookup expressions, as shown in these simple statements..."
Also, see the examples in this topic.
Hope this helps!
Thanks a lot for the reply.
Result table gets the data from below view:
Define Events_rt AS
SELECT ARB("EVENT_TYPE") AS "EVENT_TYPE",
ARB("BUSINESS_STEP") AS "BUSINESS_STEP",
ARB("DISPOSITION") AS "DISPOSITION",
ARB("ACTION") AS "ACTION",
ARB("BUSINESS_LOCATION") AS "BUSINESS_LOCATION",
ARB(LOCATION) AS "LOCATION",
ARB(LOCATION_DESCRIPTION) AS "LOCATION_DESCRIPTION",
ARB(LOCATION_TYPE) AS "LOCATION_TYPE",
ARB("EVENT_TIME") AS "EVENT_TIME",
ARB("EVENT_ATTRIBUTES") as "EVENT_ATTRIBUTES",
ARB("TOP_LEVEL_EPC_CODE") AS "TOP_LEVEL_EPC_CODE",
ARB("RECORD_TIME") AS "RECORD_TIME",
Count(EVENT_ID) AS "CODE_COUNTS"
GROUP BY EVENT_ID
all other columns are not erroring out except for event time and record time.Does this view has any issue.
Amrit, it is possibly the changed treamment of ARB.
What kind of error are you getting for those columns that are erroring?
Please see this topic from the Endeca Server 7.6.x Migration Guide which highlights the differences in EQL (Endeca Query Language), that took place in this release:
You will see the following: (quoting from the linked documentation):
For EQL 7.6.x, the ARB,COUNT, andCOUNTDISTINCT functions have been updated to work with multi-assign attributes.You will also see that "In 7.6, an implicit ARB is no longer added. That is, a SELECT of non-aggregate attributes is no longer allowed".
Also, see the following doc, about the ARB function: http://docs.oracle.com/cd/E40521_01/server.760/es_eql/toc.htm#ARB
In this doc, it is stated:
ARB works as follows: