Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-28056

[UI] Analytics : Explain for create throws syntax error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 5.5.0
    • 6.5.0
    • analytics
    • 4 node ubuntu 16 cluster running KV, index, query, analytics
    • Untriaged
    • Ubuntu 64-bit
    • Unknown
    • CX Sprint 153

    Description

      • Create a data bucket 
      • Try to EXPLAIN create shadow dataset ds2 on bucket_1

      Getting following exception but if i execute the same command it goes through fine

      [
      {
      "code": 1,
      "msg": "Syntax error: In line 1 >>explain create shadow dataset ds2 on bucket_1;<< Encountered \"create\" at column 9. ",
      "query_from_user": "create shadow dataset ds2 on bucket_1"
      }
      ]

      * Similar query in N1QL is giving response for EXPLAIN

      CREATE PRIMARY INDEX ON `travel-sample`
       
      {
      "plan": {
      "#operator": "CreatePrimaryIndex",
      "index": "#primary",
      "keyspace": "travel-sample",
      "namespace": "default",
      "using": "default"
      },
      "text": "CREATE PRIMARY INDEX ON `travel-sample`"
      }

      Attachments

        Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            The value of a plan for a DDL is very limited.

            sachin.smotra Sachin Smotra (Inactive) added a comment - The value of a plan for a DDL is very limited.

            Need to decide on the desired result for DDL statements.

             

            till Till Westmann added a comment - Need to decide on the desired result for DDL statements.  
            dmitry.lychagin Dmitry Lychagin (Inactive) added a comment - Fixed by  https://asterix-gerrit.ics.uci.edu/#/c/3420/

            Explain for DDLs is not supported in SQL++. Error message is now better:

            [
              {
                "code": 24000,
                "msg": "Syntax error: EXPLAIN is not supported for this kind of statement (in line 1, at column 1)",
                "query_from_user": "create dataset ds3 on `beer-sample`;"
              }
            ]
            

            ritesh.agarwal Ritesh Agarwal added a comment - Explain for DDLs is not supported in SQL++. Error message is now better: [ { "code": 24000, "msg": "Syntax error: EXPLAIN is not supported for this kind of statement (in line 1, at column 1)", "query_from_user": "create dataset ds3 on `beer-sample`;" } ]

            People

              dmitry.lychagin Dmitry Lychagin (Inactive)
              vikas.chaudhary Vikas Chaudhary
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty