Description
Create default bucket
Create primary index on default bucket
Create prepared statement:
PREPARE SELECT count(1) AS cnt from default WHERE join_mo > 7 and join_day > 1 |
Run:
curl -u Administrator:password -v http://192.168.10.10:8093/query/service -d 'prepared="[192.168.10.10:8091]c2a9caa3-dd85-5e46-b57d-b296f35fe64f"' |
Works fine
Then utf-8 encoded then following:
{u'name': u'[192.168.10.10:8091]c2a9caa3-dd85-5e46-b57d-b296f35fe64f', u'text': u'PREPARE SELECT count(*) AS cnt from default WHERE join_mo > 7 and join_day > 1', u'indexApiVersion': 3, u'encoded_plan': u'H4sIAAAAAAAA/6RUX2/aPhT9Ktb5vZSfTMWfAq3fUMW0SdWGSrc9dAiMfZO6DXbmOB2syj775ARKWfu0SUjY956ce3PuuXkCWeU06UWeSQsBcCQkQ+np0tngXVZAdDiM1bQZ5+YL+cI4C9HnsHJNEFA9eaGk7Le1Ph+0B3Q2bK8GI91e9S6GSX+Q0PAsAYfLycvgPMQT/jtcMKPvJVlF4Pil7kymPVmI22PQuAx3zpufEZV782gySqmIVFemCDX8RvqUAgQ0JbLMgtj9g2PqzSPEqJpX+xp/1cSHqMFMSdsHh3KP5AuI2+bETk6Wu4LL0+W9M3axdstWa498I6/l9hiwpiAPqNbp0ugjgHKlDSf/t1qYcyQmC+QX+zaenllG7FvZ6fQVe7uhFkTwJVW7kULA6E1Dg11skXpX5guZpjWxTFNPqQxR79sXVwhcfvr88QYctMmjQN3IoGtvPNA2dwVEu1ur3vDGHHr9oaRzfb4669EoUYPnqrl396RC7a5oy+C3iwfaxqr9yBHPuVR0GDEaD76OFrm0Tbe0kSo0r8zhpU2pDhursrIxcocjcz8gMELF3850Uc2rOUdZGJtCIC1MjX1pjqn0Mssowz9azAQjs2kjBTg8FWUWFoH8eid/EVfOhoPqr9wRFT+mfWfsgbSaV/H3B2QWPMl1/SwKk9r6E1D7ysalsuV6RR4VR6BNDEyvJ9Px9YTNJleTyxu2r87GM6ZsYIl3a7YbCPv6fnI9YTsPNvYkNmLSarbfhH20i+p3AAAA//+sB5p5kwQAAA==', u'signature': {u'cnt': u'number'}, u'operator': {u'#operator': u'Sequence', u'~children': [{u'#operator': u'Authorize', u'privileges': {u'List': [{u'Target': u'default:default', u'Priv': 7}]}, u'~child': {u'#operator': u'Sequence', u'~children': [{u'filter_covers': {u'cover ((7 < (`default`.`join_mo`)))': True}, u'index': u'idx_cover', u'namespace': u'default', u'covers': [u'cover ((`default`.`join_mo`))', u'cover ((`default`.`join_day`))', u'cover ((meta(`default`).`id`))', u'cover (count(*))'], u'keyspace': u'default', u'#operator': u'IndexScan3', u'index_projection': {u'entry_keys': [3]}, u'spans': [{u'range': [{u'low': u'7', u'inclusion': 0}, {u'low': u'1', u'inclusion': 0}], u'exact': True}], u'using': u'gsi', u'index_group_aggs': {u'aggregates': [{u'aggregate': u'COUNT', u'expr': u'1', u'keypos': -1, u'id': 3}]}, u'index_id': u'236ae8d8b42e7fc5'}, {u'#operator': u'Parallel', u'~child': {u'#operator': u'Sequence', u'~children': [{u'#operator': u'InitialProject', u'result_terms': [{u'expr': u'cover (count(*))', u'as': u'cnt'}]}, {u'#operator': u'FinalProject'}]}}]}}, {u'#operator': u'Stream'}]}, u'featureControls': 0} |
And run the curl command with the utf-8 ecoded params:
curl -u Administrator:password -v http://192.168.10.10:8093/query/service -d 'prepared=%7B%22name%22%3A%20%22%5B192.168.10.10%3A8091%5Dc2a9caa3-dd85-5e46-b57d-b296f35fe64f%22%2C%20%22text%22%3A%20%22PREPARE%20SELECT%20count(%2A)%20AS%20cnt%20from%20default%20WHERE%20join_mo%20%3E%207%20and%20join_day%20%3E%201%22%2C%20%22indexApiVersion%22%3A%203%2C%20%22encoded_plan%22%3A%20%22H4sIAAAAAAAA%2F7RU0U7bMBT9Fevw0k7uBJTS4bcKlW0SDxFF2wOrWmPfBENiZ46D6FD27ZPTZAi6PcC0pyj3Hp977vFJHkFWOU16VebSQgAcKclQezp1NniXVxD7HMZqepiV5gv5yjgLMeawsiAIqEN5oqQcj7T%2BMBlN6Oh4dD2Z6tH14clxOp6kdHyUgsOV5GVwHuIRe08vWND3mqwicPxUNybXnizE1XPQrA43zpsfEVV6c29yyqiKVOemCi38UvqMAgQ0pbLOg%2Bie4Ei8uYeYNsumn%2FEmEYk3hfSbhZJ2jM4SCOyV23pfWpXe3ZIKrU2P6LqrO9pABF9Tw3FHm6qUip7UYmvnbrWujM0gkFUGDX8u6IyCusEr6F4SJNLLPKcc%2F%2BTLmckDeXAoZ7XZ7o3BYMq%2B1fv7Y8UG627%2B%2Bv361hm7Ktx6OGTSajY4%2BCtIy816OBzuaP5sTTAy%2F%2BhdXYJDZpmnTIaYhisoV9sweDfEkiOLiGh77CybZbPLFMgXpI0M9Gq6l1dh7Bs0%2FZfr6AxKtikEh6eqzsMqLlu1aFnFz9bGHj2U8cxvjc2fN%2BvJoou7Ri6CJ1m0Z1GZzLa%2Fj6g9zhCwdXFNHg1HoIdYSC7myexizhbz8%2FnpJeuHs9mCKRtY6l3BujSwr5%2FmF3PWxWYbFmLTNjx9TPrqAZpfAQAA%2F%2F8ws2%2BGzwQAAA%3D%3D%22%2C%20%22signature%22%3A%20%7B%22cnt%22%3A%20%22number%22%7D%2C%20%22operator%22%3A%20%7B%22%23operator%22%3A%20%22Sequence%22%2C%20%22~children%22%3A%20%5B%7B%22%23operator%22%3A%20%22Authorize%22%2C%20%22privileges%22%3A%20%7B%22List%22%3A%20%5B%7B%22Target%22%3A%20%22default%3Adefault%22%2C%20%22Priv%22%3A%207%7D%5D%7D%2C%20%22~child%22%3A%20%7B%22%23operator%22%3A%20%22Sequence%22%2C%20%22~children%22%3A%20%5B%7B%22index%22%3A%20%22%23primary%22%2C%20%22namespace%22%3A%20%22default%22%2C%20%22keyspace%22%3A%20%22default%22%2C%20%22%23operator%22%3A%20%22PrimaryScan3%22%2C%20%22index_projection%22%3A%20%7B%22primary_key%22%3A%20true%7D%2C%20%22using%22%3A%20%22gsi%22%7D%2C%20%7B%22keyspace%22%3A%20%22default%22%2C%20%22%23operator%22%3A%20%22Fetch%22%2C%20%22namespace%22%3A%20%22default%22%7D%2C%20%7B%22%23operator%22%3A%20%22Parallel%22%2C%20%22~child%22%3A%20%7B%22%23operator%22%3A%20%22Sequence%22%2C%20%22~children%22%3A%20%5B%7B%22%23operator%22%3A%20%22Filter%22%2C%20%22condition%22%3A%20%22((7%20%3C%20(%60default%60.%60join_mo%60))%20and%20(1%20%3C%20(%60default%60.%60join_day%60)))%22%7D%2C%20%7B%22%23operator%22%3A%20%22InitialGroup%22%2C%20%22aggregates%22%3A%20%5B%22count(%2A)%22%5D%2C%20%22group_keys%22%3A%20%5B%5D%7D%5D%7D%7D%2C%20%7B%22%23operator%22%3A%20%22IntermediateGroup%22%2C%20%22aggregates%22%3A%20%5B%22count(%2A)%22%5D%2C%20%22group_keys%22%3A%20%5B%5D%7D%2C%20%7B%22%23operator%22%3A%20%22FinalGroup%22%2C%20%22aggregates%22%3A%20%5B%22count(%2A)%22%5D%2C%20%22group_keys%22%3A%20%5B%5D%7D%2C%20%7B%22%23operator%22%3A%20%22Parallel%22%2C%20%22~child%22%3A%20%7B%22%23operator%22%3A%20%22Sequence%22%2C%20%22~children%22%3A%20%5B%7B%22%23operator%22%3A%20%22InitialProject%22%2C%20%22result_terms%22%3A%20%5B%7B%22expr%22%3A%20%22count(%2A)%22%2C%20%22as%22%3A%20%22cnt%22%7D%5D%7D%2C%20%7B%22%23operator%22%3A%20%22FinalProject%22%7D%5D%7D%7D%5D%7D%7D%2C%20%7B%22%23operator%22%3A%20%22Stream%22%7D%5D%7D%2C%20%22featureControls%22%3A%200%7D'
Return the following error:
{"code":4040,"msg":"No such prepared statement: {\"name\": \"[192.168.10.10:8091]c2a9caa3-dd85-5e46-b57d-b296f35fe64f\", \"text\": \"PREPARE SELECT count(*) AS cnt from default WHERE join_mo \u003e 7 and join_day \u003e 1\", \"indexApiVersion\": 3, \"encoded_plan\": \"H4sIAAAAAAAA/7RU0U7bMBT9Fevw0k7uBJTS4bcKlW0SDxFF2wOrWmPfBENiZ46D6FD27ZPTZAi6PcC0pyj3Hp977vFJHkFWOU16VebSQgAcKclQezp1NniXVxD7HMZqepiV5gv5yjgLMeawsiAIqEN5oqQcj7T+MBlN6Oh4dD2Z6tH14clxOp6kdHyUgsOV5GVwHuIRe08vWND3mqwicPxUNybXnizE1XPQrA43zpsfEVV6c29yyqiKVOemCi38UvqMAgQ0pbLOg+ie4Ei8uYeYNsumn/EmEYk3hfSbhZJ2jM4SCOyV23pfWpXe3ZIKrU2P6LqrO9pABF9Tw3FHm6qUip7UYmvnbrWujM0gkFUGDX8u6IyCusEr6F4SJNLLPKcc/+TLmckDeXAoZ7XZ7o3BYMq+1fv7Y8UG627++v361hm7Ktx6OGTSajY4+CtIy816OBzuaP5sTTAy/+hdXYJDZpmnTIaYhisoV9sweDfEkiOLiGh77CybZbPLFMgXpI0M9Gq6l1dh7Bs0/Zfr6AxKtikEh6eqzsMqLlu1aFnFz9bGHj2U8cxvjc2fN+vJoou7Ri6CJ1m0Z1GZzLa/j6g9zhCwdXFNHg1HoIdYSC7myexizhbz8/npJeuHs9mCKRtY6l3BujSwr5/mF3PWxWYbFmLTNjx9TPrqAZpfAQAA//8ws2+GzwQAAA==\", \"signature\": {\"cnt\": \"number\"}, \"operator\": {\"#operator\": \"Sequence\", \"~children\": [{\"#operator\": \"Authorize\", \"privileges\": {\"List\": [{\"Target\": \"default:default\", \"Priv\": 7}]}, \"~child\": {\"#operator\": \"Sequence\", \"~children\": [{\"index\": \"#primary\", \"namespace\": \"default\", \"keyspace\": \"default\", \"#operator\": \"PrimaryScan3\", \"index_projection\": {\"primary_key\": true}, \"using\": \"gsi\"}, {\"keyspace\": \"default\", \"#operator\": \"Fetch\", \"namespace\": \"default\"}, {\"#operator\": \"Parallel\", \"~child\": {\"#operator\": \"Sequence\", \"~children\": [{\"#operator\": \"Filter\", \"condition\": \"((7 \u003c (`default`.`join_mo`)) and (1 \u003c (`default`.`join_day`)))\"}, {\"#operator\": \"InitialGroup\", \"aggregates\": [\"count(*)\"], \"group_keys\": []}]}}, {\"#operator\": \"IntermediateGroup\", \"aggregates\": [\"count(*)\"], \"group_keys\": []}, {\"#operator\": \"FinalGroup\", \"aggregates\": [\"count(*)\"], \"group_keys\": []}, {\"#operator\": \"Parallel\", \"~child\": {\"#operator\": \"Sequence\", \"~children\": [{\"#operator\": \"InitialProject\", \"result_terms\": [{\"expr\": \"count(*)\", \"as\": \"cnt\"}]}, {\"#operator\": \"FinalProject\"}]}}]}}, {\"#operator\": \"Stream\"}]}, \"featureControls\": 0}"} |