Hi Team,

I got number format exception for empty string and after googling i found
that this issue is bit related to DRILL-1874
<https://issues.apache.org/jira/browse/DRILL-1874> .

Q) Is it fixed in 1.6 ? Since it is very basic problem which can occur
anytime.

After reading comments of drill-1874 , i used *alter session set
planner.safe_cast_varchar = true;* but it is giving me below error, Please
let me know if i am missing anything :


0: jdbc:drill:> *alter session set planner.safe_cast_varchar = true*;
Error: VALIDATION ERROR: The option 'planner.safe_cast_varchar' does not
exist.


[Error Id: b9a8bcc4-91e3-46e9-8cf8-55aada95383b on datanode3:31010]
(state=,code=0)
java.sql.SQLException: VALIDATION ERROR: The option
'planner.safe_cast_varchar' does not exist.


[Error Id: b9a8bcc4-91e3-46e9-8cf8-55aada95383b on datanode3:31010]


    at
org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:247)
    at
org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:290)
    at
org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1923)
    at
org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:73)
    at
net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:404)
    at
net.hydromatic.avatica.AvaticaStatement.executeQueryInternal(AvaticaStatement.java:355)
    at
net.hydromatic.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:338)
    at
net.hydromatic.avatica.AvaticaStatement.execute(AvaticaStatement.java:69)
    at
org.apache.drill.jdbc.impl.DrillStatementImpl.execute(DrillStatementImpl.java:101)
    at sqlline.Commands.execute(Commands.java:841)
    at sqlline.Commands.sql(Commands.java:751)
    at sqlline.SqlLine.dispatch(SqlLine.java:746)
    at sqlline.SqlLine.begin(SqlLine.java:621)
    at sqlline.SqlLine.start(SqlLine.java:375)
    at sqlline.SqlLine.main(SqlLine.java:268)
Caused by: org.apache.drill.common.exceptions.UserRemoteException:
VALIDATION ERROR: The option 'planner.safe_cast_varchar' does not exist.


[Error Id: b9a8bcc4-91e3-46e9-8cf8-55aada95383b on datanode3:31010]


    at
org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:119)
    at
org.apache.drill.exec.rpc.user.UserClient.handleReponse(UserClient.java:113)
    at
org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:46)
    at
org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:31)
    at org.apache.drill.exec.rpc.RpcBus.handle(RpcBus.java:67)
    at org.apache.drill.exec.rpc.RpcBus$RequestEvent.run(RpcBus.java:374)
    at
org.apache.drill.common.SerializedExecutor$RunnableProcessor.run(SerializedExecutor.java:89)
    at
org.apache.drill.exec.rpc.RpcBus$SameExecutor.execute(RpcBus.java:252)
    at
org.apache.drill.common.SerializedExecutor.execute(SerializedExecutor.java:123)
    at
org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:285)
    at
org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:257)
    at
io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89)
    at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
    at
io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
    at
io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:254)
    at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
    at
io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
    at
io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103)
    at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
    at
io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
    at
io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242)
    at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
    at
io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
    at
io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)
    at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
    at
io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
    at
io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847)
    at
io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe.epollInReady(AbstractEpollStreamChannel.java:618)
    at
io.netty.channel.epoll.EpollEventLoop.processReady(EpollEventLoop.java:329)
    at io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:250)
    at
io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
    at java.lang.Thread.run(Thread.java:745)


Also when i am trying to exclude empty string i.e. *col_name <> ''* then it
is excluding null values as well.

Regards,
*Anup Tiwari*

Reply via email to