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." **********************************************************************