Passing Query to Hive Variable in Hue (not able to see results)

Asked Dec 30 '21 at 21:50

Active Dec 31 '21 at 09:25

Viewed 349 times

I am trying to capture all column names of table in Variable

set col_names=show columns in Table_X;
select '${hiveconf:col_names}'

It doesn't work. It results literal value. I also tried .

set col_names=$(hive -e "show columns in Table_X;") ;
select '${hiveconf:col_names}'

It doesn't work. It brings back no values.

I am sure Its syntax issue and not limitation of Hive .

edited Dec 31 '21 at 09:17

Raul Saucedo

asked Dec 30 '21 at 21:50

Tinu

Not sure if you can do this. However you can use py script to collect all metadata and put into a table. Or else you can use hive metastore. – Koushik Roy Dec 31 '21 at 05:16
Unfortunately - I need to work in Hue , so my choices are limited – Tinu Dec 31 '21 at 14:22
I do t understand How can you run hive -e command in hue? Anyways, sorry, not sure of any idea. – Koushik Roy Dec 31 '21 at 15:02

0 Answers0