Details
-
Bug
-
Resolution: Fixed
-
Minor
-
4.0.0
-
Security Level: Public
-
None
-
Untriaged
-
Unknown
Description
Explain has all the other info about the statement, except the statement itself.
It's a bit easier to collect the explain in a script if the statement is also available within the explain.
cbq> explain select C_STATE, C_CREDIT, avg(C_CREDIT_LIM) as AVG_CR_LIMIT from CUSTOMER group by C_STATE, C_CREDIT ORDER BY AVG_CR}
{
"requestID": "b9c8490c-ae00-4cb0-a35f-84292ed9864b",
"signature": "json",
"results": [
{
"#operator": "Sequence",
"~children": [
{
"#operator": "Sequence",
"~children": [
,
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
,
,
{ "#operator": "IntermediateGroup", "aggregates": [ "avg((`CUSTOMER`.`C_CREDIT_LIM`))" ], "group_keys": [ "(`CUSTOMER`.`C_STATE`)", "(`CUSTOMER`.`C_CREDIT`)" ] } ]
}
},
,
,
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "InitialProject",
"result_terms": [
,
,
{ "as": "AVG_CR_LIMIT", "expr": "avg((`CUSTOMER`.`C_CREDIT_LIM`))" } ]
}
]
}
}
]
},
{
"#operator": "Order",
"sort_terms": [
]
},
{
"#operator": "Parallel",
"~child":
}
]
}
],
"status": "success",
"metrics":
}
cbq>