Skip to content

execinfrapb: print out input types for EXPLAIN (DISTSQL, TYPES)#43193

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
yuzefovich:explain-input-types
Dec 17, 2019
Merged

execinfrapb: print out input types for EXPLAIN (DISTSQL, TYPES)#43193
craig[bot] merged 1 commit intocockroachdb:masterfrom
yuzefovich:explain-input-types

Conversation

@yuzefovich
Copy link
Copy Markdown
Member

@yuzefovich yuzefovich commented Dec 16, 2019

This change adds printing out the column types for InputSyncSpec in the
flow diagram. This could be useful to understand the issue when a type
mismatch occurs.

Release note (sql change): Column types will now be displayed in the box
for the input synchronizer in the flow diagram obtained via EXPLAIN
(DISTSQL, TYPES).

@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

@yuzefovich yuzefovich requested a review from a team as a code owner December 16, 2019 21:47
@RaduBerinde
Copy link
Copy Markdown
Member

How often do you think this will be useful? It adds a bit more clutter to already cluttered diagrams, and it makes the URLs longer. If it's just to debug specific cases, we could consider having an EXPLAIN (DISTSQL, TYPES) version (we already support the TYPES keyword).

@yuzefovich
Copy link
Copy Markdown
Member Author

I don't think it'll be useful very often, and I like your suggestion about TYPES keyword (I was thinking about VERBOSE, but TYPES seems better), so I'll look into it.

This change adds printing out the column types for InputSyncSpec in the
flow diagram. This could be useful to understand the issue when a type
mismatch occurs.

Release note (sql change): Column types will now be displayed in the box
for the input synchronizer in the flow diagram obtained via EXPLAIN
(DISTSQL, TYPES).
@yuzefovich yuzefovich changed the title execinfrapb: add input types to EXPLAIN (DISTSQL) diagrams execinfrapb: print out input types for EXPLAIN (DISTSQL, TYPES) Dec 17, 2019
@yuzefovich
Copy link
Copy Markdown
Member Author

Updated the PR, RFAL.

Copy link
Copy Markdown
Member

@RaduBerinde RaduBerinde left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

:lgtm:

Reviewable status: :shipit: complete! 1 of 0 LGTMs obtained (waiting on @jordanlewis and @RaduBerinde)

@yuzefovich
Copy link
Copy Markdown
Member Author

TFTR!

bors r+

craig bot pushed a commit that referenced this pull request Dec 17, 2019
43193: execinfrapb: print out input types for EXPLAIN (DISTSQL, TYPES) r=yuzefovich a=yuzefovich

This change adds printing out the column types for InputSyncSpec in the
flow diagram. This could be useful to understand the issue when a type
mismatch occurs.

Release note (sql change): Column types will now be displayed in the box
for the input synchronizer in the flow diagram obtained via EXPLAIN
(DISTSQL, TYPES).

Co-authored-by: Yahor Yuzefovich <yahor@cockroachlabs.com>
@craig
Copy link
Copy Markdown
Contributor

craig bot commented Dec 17, 2019

Build succeeded

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants