select * is displaying a few extra fields that are not required. This happens only for certain meta().id’s and not for all.
However, we need only the information that’s part of results array .
Can someone assist on this?
Thanks
Ajay
Example
{
"requestID": "321640e3-332d-475d-8877-913b6e6e83a0",
"clientContextID": "2bf5d993-c0cc-48d2-a419-c2b36818ec55",
"signature": {
"*": "*"
},
**"results": [**
** content........**
** ],**
"status": "success",
"metrics": {
"elapsedTime": "3.467506ms",
"executionTime": "3.42304ms",
"resultCount": 1,
"resultSize": 8392
},
"profile": {
"phaseTimes": {
"authorize": "739.118µs",
"fetch": "328.734µs",
"filter": "40.555µs",
"indexScan": "884.774µs",
"instantiate": "23.248µs",
"parse": "597.337µs",
"plan": "382.712µs",
"run": "2.406039ms"
},
"phaseCounts": {
"fetch": 1,
"filter": 1,
"indexScan": 1
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1
},
"executionTimings": {
"#operator": "Sequence",
"#stats": {
"#phaseSwitches": 1,
"execTime": "1.418µs"
},
"~children": [
{
"#operator": "Authorize",
"#stats": {
"#phaseSwitches": 3,
"execTime": "3.856µs",
"servTime": "735.262µs"
},
"privileges": {
"List": [
{
"Target": "default:cb_scrsu_dcshelper_int_gc_io_1",
"Priv": 7
}
]
},
"~child": {
"#operator": "Sequence",
"#stats": {
"#phaseSwitches": 1,
"execTime": "2.715µs"
},
"~children": [
{
"#operator": "IndexScan3",
"#stats": {
"#itemsOut": 1,
"#phaseSwitches": 7,
"execTime": "16.518µs",
"kernTime": "1.277µs",
"servTime": "868.256µs"
},
"index": "dcs_metaid",
"index_id": "ec7098c12ee521f9",
"index_projection": {
"primary_key": true
},
"keyspace": "cb_scrsu_dcshelper_int_gc_io_1",
"namespace": "default",
"spans": [
{
"exact": true,
"range": [
{
"high": "\"SR::FS::SU2587878879\"",
"inclusion": 1,
"low": "\"SR::FS::SU2587878878\""
}
]
}
],
"using": "gsi"
},
{
"#operator": "Fetch",
"#stats": {
"#itemsIn": 1,
"#itemsOut": 1,
"#phaseSwitches": 9,
"execTime": "15.22µs",
"kernTime": "900.23µs",
"servTime": "313.514µs"
},
"keyspace": "cb_scrsu_dcshelper_int_gc_io_1",
"namespace": "default"
},
{
"#operator": "Sequence",
"#stats": {
"#phaseSwitches": 1,
"execTime": "2.32µs"
},
"~children": [
{
"#operator": "Filter",
"#stats": {
"#itemsIn": 1,
"#itemsOut": 1,
"#phaseSwitches": 7,
"execTime": "40.555µs",
"kernTime": "1.236929ms"
},
"condition": "((meta(`cb_scrsu_dcshelper_int_gc_io_1`).`id`) like \"SR::FS::SU2587878878%\")"
},
{
"#operator": "InitialProject",
"#stats": {
"#itemsIn": 1,
"#itemsOut": 1,
"#phaseSwitches": 8,
"execTime": "5.386µs",
"kernTime": "1.282337ms"
},
"result_terms": [
{
"expr": "self",
"star": true
}
]
},
{
"#operator": "FinalProject",
"#stats": {
"#itemsIn": 1,
"#itemsOut": 1,
"#phaseSwitches": 4,
"execTime": "2.232µs",
"kernTime": "23.716µs"
}
}
]
}
]
}
},
{
"#operator": "Stream",
"#stats": {
"#itemsIn": 1,
"#itemsOut": 1,
"#phaseSwitches": 5,
"execTime": "313.299µs",
"kernTime": "2.0668ms"
}
}
],
"~versions": [
"6.6.3-N1QL",
"6.6.3-9808-enterprise"
]
}
}
}