[DRILL-6860] SqlLine: EXPLAIN produces very long header lines

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 1.14.0
• Component/s: Client - CLI
• Assignee: Arina Ielchiieva
• Reporter: Boaz Ben-Zvi
• Created: 16/Nov/18 00:52
• Updated: 19/Nov/18 15:22
• Resolved: 19/Nov/18 15:21

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)

Issue Links

• duplicates: DRILL-6769 Sqlline doesn't see line endings when it prints first row fo the explain plan results table