[IMPALA-1067] Passing Arguments through Impala Shell

• Type: New Feature
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 1.3.1, Impala 1.4, Impala 2.0, Impala 2.1, Impala 2.2
• Component/s: Clients
• Labels: arguments/parameters impala impala-shell ramp-up shell
• Environment: CentOS 6.5
• Target Version: Impala 2.5.0
• Assignee: Andre Araujo
• Reporter: Adharsh Krishnan S
• Created: 30/Jun/14 10:08
• Updated: 04/Jan/17 23:58
• Resolved: 11/Feb/16 17:26

Description

The following line is a part of the script file.

(CASE WHEN(cast(now() as int)-cast(record_time as int) >= 60) THEN "R" ELSE "P" END)

I need to pass the value 60 as an argument, the value of 60 should be passed as parameter/argument from impala shell.

If we do that in shell script, it affects the performance, as it has to invoke a shell and quit the impala shell for every line of the script.

Thank you.

Warm regards,
Adharsh