Drill - Error creating views

[Sudip Mukherjee <sm...@commvault.com>]

Hi Devs,

I am getting the below exception while trying to create view from Web UI. Could you please take a look on how to troubleshoot this?

org.apache.drill.common.exceptions.UserRemoteException: PARSE ERROR: java.lang.IndexOutOfBoundsException: index (43) must be less than size (43)


QUERY that I gave is below :

CREATE OR REPLACE VIEW dfs.myviews.downloadcenterdataview as SELECT `bollink`,`category`,`categoryname`,`categoryid`,`downloadtype`,`earlypreviewusers`,`installpreference`,`notificationcontent`,`notificationusers`,`notvisibleto`,`packagedescription`,`packageid`,`packageplatformmappingid`,`packagelocation`,`packagename`,`packagesize`,`packagestatus`,`platform`,`platformname`,`productversion`,`productversionname`,`readmelocation`,`recutnumber`,`subcategory`,`subcategoryid`,`subcategoryname`,`validfrom`,`validto`,`vendor`,`visibleto`,`bolcontent`,`readmecontent`,`content`,`createtime`,`modifiedtime`,`serverid`,`softwareicon`,`reportname`,`reportdescription`,`reportguid`,`reportrevision`,`reportformat`,`includeTable`,`includeChart`,`itemrank`,`priceweightage` from mydb.downloadcenterdata

Stack trace :

2015-09-10 01:09:55,109 [qtp727140336-1839] ERROR o.a.d.e.server.rest.QueryResources - Query from Web UI Failed
org.apache.drill.common.exceptions.UserRemoteException: PARSE ERROR: java.lang.IndexOutOfBoundsException: index (43) must be less than size (43)

                at org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:118) ~[drill-java-exec-1.2.0-SNAPSHOT.jar:1.2.0-SNAPSHOT]
                at org.apache.drill.exec.rpc.user.UserClient.handleReponse(UserClient.java:111) ~[drill-java-exec-1.2.0-SNAPSHOT.jar:1.2.0-SNAPSHOT]
                at org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:47) ~[drill-java-exec-1.2.0-SNAPSHOT.jar:1.2.0-SNAPSHOT]
                at org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:32) ~[drill-java-exec-1.2.0-SNAPSHOT.jar:1.2.0-SNAPSHOT]
                at org.apache.drill.exec.rpc.RpcBus.handle(RpcBus.java:61) ~[drill-java-exec-1.2.0-SNAPSHOT.jar:1.2.0-SNAPSHOT]
                at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:233) ~[drill-java-exec-1.2.0-SNAPSHOT.jar:1.2.0-SNAPSHOT]
                at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:205) ~[drill-java-exec-1.2.0-SNAPSHOT.jar:1.2.0-SNAPSHOT]
                at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89) ~[netty-codec-4.0.27.Final.jar:4.0.27.Final]

Thanks,
Sudip



***************************Legal Disclaimer***************************
"This communication may contain confidential and privileged material for the
sole use of the intended recipient. Any unauthorized review, use or distribution
by others is strictly prohibited. If you have received the message by mistake,
please advise the sender by reply email and delete the message. Thank you."
**********************************************************************