hive> set hive.cli.print.current.db=true; ----------------------> It will show the current database
hive (mhtprabhu_new)>
hive (mhtprabhu_new)>
----------------------------------------------------------------------------------------------------------------------------
hive (mhtprabhu_new)>set hive.cli.print.header=true; ----------------->It will show the table data with salaryns header
hive (mhtprabhu_new)> select * from student3;
student3.name student3.id student3.year
subhash 800 1990
venkat 100 1991
ram 300 1992
----------------------------------------------------------------------------------------------------------------------------
hive (mhtprabhu_new)> set hive.cli.print.header=false; ----------------->It will show the table data without salaryns header
hive (mhtprabhu_new)> select * from student3;
subhash 800 1990
venkat 100 1991
ram 300 1992
subhash 200 1993
----------------------------------------------------------------------------------------------------------------------------
set hive.exec.dynamic.partition=true;
By default Hive won't allow you to create Dynamic partition unless you've atleast one Static partition. Once you set this property to true, Hive will allow to create Dynamic partition whether you have Static partition or not.
----------------------------------------------------------------------------------------------------------------------------
set hive.exec.dynamic.partition.mode=nonstrict;
mode = nonstrict; This will set the mode to non-strict. The non-strict mode means it will allow all the partition to be dynamic. It can also be called as variable partitioning.
