[jira] [Commented] (HIVE-23962) Make bin/hive pick user defined jdbc url

["Naveen Gangam (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-23962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17217885#comment-17217885 ] 

Naveen Gangam commented on HIVE-23962:
--------------------------------------

[~Rajkumar Singh] We understand that beeline-site.xml is for this purpose. This fix is a further enhancement to that feature. This allows users to control the beeline profile being used via an environment variable. With existing workloads, to change the beeline URL, user will have to
1) either change the existing URL in beeline-site.xml or
2) add a new URL to beeline-site.xml and make this the default.

The latter option works fine if you want to change it across all users. But users may want to selectively do so across some sessions but not all. Having an environment variable aids with this without having to change anything on the workload.

For example, you might want to run a workload to test performance acid tables vs non-acid tables. We can now create a new profiles in beeline-site.xml, one that enables acid tables by default and other that uses legacy-mode where tables are non-acid by default and run the workload again each like so
BEELINE_URL_LEGACY=acid
beeline -f "workload.hql"
BEELINE_URL_LEGACY=non-acid
beeline -f "workload.hql"

[~Xiaomeng Zhang] [~ychena] Could you please review this? I made a minor change to the prior fix in PR1344 where we would only use "beeline -c" when service="cli". It doesnt work when we invoke beeline.sh script. Thanks

> Make bin/hive pick user defined jdbc url 
> -----------------------------------------
>
>                 Key: HIVE-23962
>                 URL: https://issues.apache.org/jira/browse/HIVE-23962
>             Project: Hive
>          Issue Type: Bug
>          Components: HiveServer2
>    Affects Versions: 4.0.0
>            Reporter: Xiaomeng Zhang
>            Priority: Major
>              Labels: pull-request-available
>          Time Spent: 1h
>  Remaining Estimate: 0h
>
> Currently hive command will trigger bin/hive which run "beeline" by default.
> We want to pass a env variable so that user can define which url beeline use.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)