Ksql: Error occurred when I run script in ksql console with confluent version 4.1.0

Created on 3 May 2018 · 6Comments · Source: confluentinc/ksql

ksql> run script 'ksql-clickstream-demo/demo/clickstream-schema.sql';
Error reading entity from input stream.
Caused by: Missing type id when trying to resolve subtype of [simple type, class io.confluent.ksql.rest.entity.KsqlEntity]: missing type id property '@type'
 at [Source: (org.glassfish.jersey.message.internal.ReaderInterceptorExecutor$UnCloseableInputStream); line: 1, column: 1879] (through reference chain: io.confluent.ksql.rest.entity.KsqlEntityList[0])

Source

osenv

👍1

Most helpful comment

Which version of the CLI are you using?

apurvam on 5 May 2018

🎉1 😄1 👍1

All 6 comments

Which version of the CLI are you using?

apurvam on 5 May 2018

🎉1 😄1 👍1

and which version of the server?

apurvam on 5 May 2018

👍1

Hi apurvam,

Thanks for your reply. I am using the Confluent Open Source: 4.1.0.

osenv on 7 May 2018

@lecodet :

1) Does this happen with every SQL file, or just this particular one? If the latter, are you able to share the contents of the file?
2) Have you tried it on 5.0?

rmoff on 26 Jul 2018

Which version of the CLI are you using?

This was my problem. I ran the docker client without specifying a version and it fetched 'latest'. It was fixed after I specified 4.1.2, which was the version of the server I was using.

fjbsantiago on 28 Feb 2019

Since this has been fixed in more recent versions (and more-so, we've deprecated runscript in favor of multiple statements) I'm going to close out this issue as part of an effort to clean up our backlog. Please let me know if this issue persists in more recent versions!