[
https://issues.apache.org/jira/browse/HIVE-3044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13281401#comment-13281401
]
Kristam Subba Swathi commented on HIVE-3044:
--------------------------------------------
Please find the exception trace for more details
{noformat}
2012-05-23 10:20:05,911 ERROR ql.Driver (SessionState.java:printError(400)) -
FAILED: ParseException line 1:7 cannot recognize input near 'index' '('
'number' in select clause
org.apache.hadoop.hive.ql.parse.ParseException: line 1:7 cannot recognize input
near 'index' '(' 'number' in select clause
at
org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:441)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:415)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:335)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:901)
at
org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:191)
at
org.apache.hadoop.hive.service.ThriftHive$Processor$execute.getResult(ThriftHive.java:629)
at
org.apache.hadoop.hive.service.ThriftHive$Processor$execute.getResult(ThriftHive.java:617)
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:176)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
{noformat}
> INDEX UDF is not working
> ------------------------
>
> Key: HIVE-3044
> URL: https://issues.apache.org/jira/browse/HIVE-3044
> Project: Hive
> Issue Type: Bug
> Components: UDF
> Affects Versions: 0.8.1
> Reporter: Kristam Subba Swathi
> Assignee: Chinna Rao Lalam
>
> Steps to reproduce
> ----------------------
> Create the table and load data
> Execute the index query
> Please find the sample code
> {code}
> createStatement.executeQuery("create table sample4(number array<int>)
> partitioned by (part2 STRING)");
> createStatement.executeQuery("load data local inpath
> '/home/hivecurwork/data/array.txt' into table sample4 partition (part2='x')");
> ResultSet executeQuery1 = createStatement.executeQuery("select
> index(number,3) from sample4");
> while(executeQuery1.next())
> {
> System.out.println("res:"+executeQuery1.getString(1));
> }
>
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
