[Herddb-dev] Issue with describe table

Enrico Olivelli eolivelli at gmail.com
Thu May 2 08:51:09 CEST 2019


We have never implemented DESCRIBE
so your are passing by an unknown code path.


for your new feature "SHOW CREATE" you don't have to reach Calcite.
Like what we do for "EXECUTE",
I think you don't have to pass from jSQLParser as well
I would check if the statement starts with something like SHOW CREATE ......
and then do you new code




Enrico

Il giorno gio 2 mag 2019 alle ore 08:38 Amit Chavan
<achavan1 at gmail.com> ha scritto:
>
> Hello,
>
> I added a table called tsql2 into the system. When I do 'describe tsql2' i get the following error -
>
> ./herddb-cli.sh -q "DESCRIBE tsql2"
> read system property: herddb.vint.read.folded=false
> read system property: herddb.vint.write.folded=false
> error:java.sql.SQLException: herddb.model.StatementExecutionException: From line 1, column 10 to line 1, column 14: Column 'TSQL2' not found in any table
>   at herddb.sql.CalcitePlanner.translate(CalcitePlanner.java:337)
>   at herddb.server.ServerSideConnectionPeer.handleExecuteStatement(ServerSideConnectionPeer.java:707)
>   at herddb.server.ServerSideConnectionPeer.requestReceived(ServerSideConnectionPeer.java:140)
>   at herddb.network.netty.NettyChannel.lambda$handlePduRequest$1(NettyChannel.java:93)
>   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>   at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
>   at java.util.concurrent.FutureTask.run(FutureTask.java)
>   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>   at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
>   at java.lang.Thread.run(Thread.java:745)
>
> Has this functionality implemented?
>
> Thanks,
> Amit
> _______________________________________________
> herddb-dev mailing list
> herddb-dev at lists.herddb.org
> http://lists.herddb.org/mailman/listinfo/herddb-dev


More information about the herddb-dev mailing list