Created 02-20-2023 04:26 AM
I am looking for beeline equivalent for hive cli -v(echo executed SQL to the console). In beeline --verbose mode is there but it does not echo executed SQL like cli does. It just shows the error and debugging info. Is there any way i can get executed SQL for beeline?
sample queries)
hive -v -e "alter table table1 drop partition(keyword='value');" > test.log - add SQL to test.log
beeline --verbose -e "alter table table1 drop partition(keyword='value');" > test.log - does not add SQL to test.log
Created 02-21-2023 03:18 AM
@Ganeshk Can you please share hive version used for both cases?
are you using custom logging for beeline in both cases?
Created 02-27-2023 10:48 PM
@AsimShaikh version used for hive cli 1.2.1. Version used for beeline 3.1.3. I am using shell script redirect just to log into a log file. hive -v -e "alter table table1 drop partition(keyword='value');" > test.log
Created 02-27-2023 11:34 PM
@Ganeshk Yes, we do not have any flag equivalent to -v in beeline. However, if we are looking for the command itself, you could find it in the line stating "Compiling command" or "Executing command"