question Don't we have a way to select normal column along with UDTF in hive?? in Archives of Support Questions (Read Only)

Don't we have a way to select normal column along with UDTF in hive??

bsuresh — Fri, 18 Dec 2015 16:48:08 GMT

I would like to select one normal datatype column(primitive) column along with UDTF as follows.But it is throwing error like

SemanticException [Error 10081]: UDTF's are not supported outside the SELECT clause, nor nested in expressions

I understood the problem.Don't we have any way to do this.

Query is : select col1,explode(split(col2,'\\s')) from table_name;

assume col2 is int type and col2 is string.

gbraccialli3 — Fri, 18 Dec 2015 18:25:35 GMT

You have to use LATERAL VIEW to do it.

See this:

And an example here:

  select s.code, exp.splitted
  from sample_07 s
  lateral view explode(split('asdfa adsfa asdaf asdfad','\\s')) exp as splitted

bsuresh — Fri, 18 Dec 2015 18:35:09 GMT

@Guilherme Braccialli thank you.its working.