Hi, all,
I wrote a simple TMUDF which will perform a solr query and get result as a
table value.
It can work like this:
>>select * from udf(solrUDF('db','iphone'));
id description
------ ----------------------------------------
1 iphone 5
2 iphone 5s
--- 2 row(s) selected.
As you can see, it will return two columns: 'id' and 'description'. Now I want
to do a filter on id, so I try this:
>>select * from udf(solrUDF('db','iphone')) u where u.id = 1;
It failed and report this error:
*** ERROR[4003] Column U.ID is not a column in table U, or, after a NATURAL
JOIN or JOIN USING, is no longer allowed to be specified with a table
correlation name.
*** ERROR[8822] The statement was not prepared.
Because I want to join the udf result from the source Trafodion table, so I
have to reference the columns in the UDF.
Please help, how can I reference to the column returned from a UDF?
Thanks,
Ming
