hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristam Subba Swathi (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-3044) INDEX UDF is not working
Date Wed, 23 May 2012 04:52:40 GMT

    [ 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

        

Mime
View raw message