Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6860

SqlLine: EXPLAIN produces very long header lines

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Duplicate
    • 1.14.0
    • None
    • Client - CLI
    • None

    Description

      Maybe a result of upgrading to SqlLine 1.5.0 (DRILL-3853 - PR #1462), the header dividing lines displayed when using EXPLAIN became very long:

      0: jdbc:drill:zk=local> explain plan for select count(*) from dfs.`/data/tpcds/sf1/parquet/date_dim`;
      +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      |                                                                                                    text                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                             json                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
      +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | 00-00    Screen
      00-01      Project(EXPR$0=[$0])
      00-02        DirectScan(groupscan=[files = [/data/tpcds/sf1/parquet/date_dim/0_0_0.parquet], numFiles = 1, DynamicPojoRecordReader{records = [[73049]]}])
        | {
        "head" : {
          "version" : 1,
          "generator" : {
            "type" : "ExplainHandler",
            "info" : ""
          },
          "type" : "APACHE_DRILL_PHYSICAL",
          "options" : [ {
            "kind" : "BOOLEAN",
            "accessibleScopes" : "ALL",
            "name" : "planner.enable_nljoin_for_scalar_only",
            "bool_val" : true,
            "scope" : "SESSION"
          } ],
          "queue" : 0,
          "hasResourcePlan" : false,
          "resultMode" : "EXEC"
        },
        "graph" : [ {
          "pop" : "metadata-direct-scan",
          "@id" : 2,
          "cost" : 1.0
        }, {
          "pop" : "project",
          "@id" : 1,
          "exprs" : [ {
            "ref" : "`EXPR$0`",
            "expr" : "`count0$EXPR$0`"
          } ],
          "child" : 2,
          "outputProj" : true,
          "initialAllocation" : 1000000,
          "maxAllocation" : 10000000000,
          "cost" : 1.0
        }, {
          "pop" : "screen",
          "@id" : 0,
          "child" : 1,
          "initialAllocation" : 1000000,
          "maxAllocation" : 10000000000,
          "cost" : 1.0
        } ]
      }  |
      +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      1 row selected (0.592 seconds)
      

      Attachments

        Issue Links

          Activity

            People

              arina Arina Ielchiieva
              ben-zvi Boaz Ben-Zvi
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: