Details
Major Description
Steps to reproduce -
- Create a 2 node cluster with 1 kv and 1 cbas node.
- Create an external link to aws bucket.
- Create an external dataset using the aws link created above.
- Run analyze analytics collection on the dataset created in step 3.
- Following error is observed -
[
|
{
|
"code": 25000, |
"msg": "Internal error", |
"query_from_user": "analyze analytics collection a;" |
}
|
]
|
Logs from analytics_info.log
2023-03-24T06:33:15.648+00:00 ERRO CBAS.translator.QueryTranslator [QueryTranslator:76d4e38f-310e-440b-bdeb-ef0eee093ee6] failed to analyze dataset; executing compensating operations
|
org.apache.asterix.common.exceptions.CompilationException: ASX0027: Operation not supported (in line 1, at column 1)
|
at org.apache.asterix.app.translator.QueryTranslator.doAnalyzeDataset(QueryTranslator.java:4249) ~[asterix-app-7.2.0-5268.jar:7.2.0-5268]
|
at com.couchbase.analytics.lang.CBStatementExecutor.doAnalyzeDataset(CBStatementExecutor.java:1473) ~[cbas-connector-7.2.0-5268.jar:7.2.0-5268]
|
at org.apache.asterix.app.translator.QueryTranslator.handleAnalyzeStatement(QueryTranslator.java:4216) ~[asterix-app-7.2.0-5268.jar:7.2.0-5268]
|
at com.couchbase.analytics.lang.CBStatementExecutor.handleAnalyzeStatement(CBStatementExecutor.java:1462) ~[cbas-connector-7.2.0-5268.jar:7.2.0-5268]
|
at org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:495) ~[asterix-app-7.2.0-5268.jar:7.2.0-5268]
|
at org.apache.asterix.app.message.ExecuteStatementRequestMessage.handle(ExecuteStatementRequestMessage.java:180) ~[asterix-app-7.2.0-5268.jar:7.2.0-5268]
|
at org.apache.asterix.messaging.CCMessageBroker.receivedMessage(CCMessageBroker.java:64) ~[asterix-app-7.2.0-5268.jar:7.2.0-5268]
|
at org.apache.hyracks.control.cc.work.ApplicationMessageWork.lambda$notifyMessageBroker$0(ApplicationMessageWork.java:68) ~[hyracks-control-cc-7.2.0-5268.jar:7.2.0-5268]
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
|
at java.lang.Thread.run(Thread.java:829) ~[?:?]
|
2023-03-24T06:33:15.649+00:00 WARN CBAS.apache.asterix [Executor-70:ClusterController] ASX0027: Operation not supported (in line 1, at column 1)
|
org.apache.asterix.common.exceptions.CompilationException: ASX0027: Operation not supported (in line 1, at column 1)
|
at org.apache.asterix.app.translator.QueryTranslator.doAnalyzeDataset(QueryTranslator.java:4249) ~[asterix-app-7.2.0-5268.jar:7.2.0-5268]
|
at com.couchbase.analytics.lang.CBStatementExecutor.doAnalyzeDataset(CBStatementExecutor.java:1473) ~[cbas-connector-7.2.0-5268.jar:7.2.0-5268]
|
at org.apache.asterix.app.translator.QueryTranslator.handleAnalyzeStatement(QueryTranslator.java:4216) ~[asterix-app-7.2.0-5268.jar:7.2.0-5268]
|
at com.couchbase.analytics.lang.CBStatementExecutor.handleAnalyzeStatement(CBStatementExecutor.java:1462) ~[cbas-connector-7.2.0-5268.jar:7.2.0-5268]
|
at org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:495) ~[asterix-app-7.2.0-5268.jar:7.2.0-5268]
|
at org.apache.asterix.app.message.ExecuteStatementRequestMessage.handle(ExecuteStatementRequestMessage.java:180) ~[asterix-app-7.2.0-5268.jar:7.2.0-5268]
|
at org.apache.asterix.messaging.CCMessageBroker.receivedMessage(CCMessageBroker.java:64) ~[asterix-app-7.2.0-5268.jar:7.2.0-5268]
|
at org.apache.hyracks.control.cc.work.ApplicationMessageWork.lambda$notifyMessageBroker$0(ApplicationMessageWork.java:68) ~[hyracks-control-cc-7.2.0-5268.jar:7.2.0-5268]
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
|
at java.lang.Thread.run(Thread.java:829) ~[?:?]
|
2023-03-24T06:33:15.651+00:00 INFO CBAS.messaging.NCMessageBroker [Worker:caf7f1ea0c0879e41ce99e2b4ad7f97c] Received message: ExecuteStatementResponseMessage(id=474): 0 characters
|
As analyze analytics collection is not supported on external dataset, we should improve the error message specifying the same.