You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I can use set var1 in Hive-SQL . can it be possible to use in odpscmd ?
Example :
-- a.sql
set tbl_name;
drop table ${tbl_name};
If I run "hive -f a.sql --define tbl_name=test_1" , then the sql will be "drop table test_1;"
If I run "hive -f a.sql --define tbl_name=test_2" , then the sql will be "drop table test_2;"
This is very convenient because I can generate different data by passing different parameters. How can I implement this feature in odpscmd?
The text was updated successfully, but these errors were encountered:
I can use set var1 in Hive-SQL . can it be possible to use in odpscmd ?
Example :
If I run "hive -f a.sql --define tbl_name=test_1" , then the sql will be "drop table test_1;"
If I run "hive -f a.sql --define tbl_name=test_2" , then the sql will be "drop table test_2;"
This is very convenient because I can generate different data by passing different parameters. How can I implement this feature in odpscmd?
The text was updated successfully, but these errors were encountered: