are you querying on csv files? On Fri, Oct 14, 2016 at 1:31 PM, Anup Tiwari <[email protected]> wrote:
> 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* > -- Nitin Pawar
