[
https://issues.apache.org/jira/browse/HIVE-3044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13400950#comment-13400950
]
Aniket Mokashi commented on HIVE-3044:
--------------------------------------
This is probably broken because index is a keyword in hive.
For example-
{code}
hive> describe function index;
org.apache.hadoop.hive.ql.parse.ParseException: line 1:18 cannot recognize
input near 'index' '<EOF>' '<EOF>' in describe statement
{code}
I can think of 2 options-
1. Fix the parser to identify this as udf
OR
2. (easier) rename the udf to get_index.
Thoughts?
The current workaround is-
create temporary function get_index as
'org.apache.hadoop.hive.ql.udf.generic.GenericUDFIndex';
> 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
