Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

EXPLAIN shows system fields twice #3039

Closed
agavra opened this issue Jul 1, 2019 · 0 comments · Fixed by #3043
Closed

EXPLAIN shows system fields twice #3039

agavra opened this issue Jul 1, 2019 · 0 comments · Fixed by #3043
Labels

Comments

@agavra
Copy link
Contributor

agavra commented Jul 1, 2019

On master (0de23d2):

ksql> CREATE STREAM foo (ID VARCHAR) WITH (kafka_topic='foo', partitions=1, value_format='json');

 Message
----------------
 Stream created
----------------

ksql> INSERT INTO foo VALUES ('a', '1');
ksql> EXPLAIN SELECT * FROM FOO;

ID                   :
SQL                  : SELECT * FROM FOO;

 Field   | Type
-------------------------------------
 ROWTIME | BIGINT           (system)
 ROWKEY  | VARCHAR(STRING)  (system)
 ROWTIME | BIGINT           (system)
 ROWKEY  | VARCHAR(STRING)  (system)
 ID      | VARCHAR(STRING)
-------------------------------------

Note that ROWTIME/ROWKEY show up twice. Might be related to recent key field work. cc @big-andy-coates

It looks like it's because for SELECT *, ROWTIME and ROWKEY are included in the "value fields".

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
1 participant