[jira] [Commented] (HIVE-5867) JDBC driver and beeline should support executing an initial SQL script

["Hive QA (JIRA)" <ji...@apache.org>]

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

Hive QA commented on HIVE-5867:
-------------------------------



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12827380/HIVE-5867.1.patch

{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 8 failed/errored test(s), 10454 tests executed
*Failed tests:*
{noformat}
TestBeeLineWithArgs - did not produce a TEST-*.xml file
TestHiveCli - did not produce a TEST-*.xml file
org.apache.hadoop.hive.cli.TestCliDriver.org.apache.hadoop.hive.cli.TestCliDriver
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_join_part_col_char]
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[acid_bucket_pruning]
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainuser_3]
org.apache.hive.jdbc.TestJdbcDriver2.testMetaDataGetColumns
org.apache.hive.jdbc.TestJdbcWithMiniHS2.testAddJarConstructorUnCaching
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-MASTER-Build/1122/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-MASTER-Build/1122/console
Test logs: http://ec2-204-236-174-241.us-west-1.compute.amazonaws.com/logs/PreCommit-HIVE-MASTER-Build-1122/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 8 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12827380 - PreCommit-HIVE-MASTER-Build

> JDBC driver and beeline should support executing an initial SQL script
> ----------------------------------------------------------------------
>
>                 Key: HIVE-5867
>                 URL: https://issues.apache.org/jira/browse/HIVE-5867
>             Project: Hive
>          Issue Type: Improvement
>          Components: Clients, JDBC
>            Reporter: Prasad Mujumdar
>            Assignee: Jianguo Tian
>         Attachments: HIVE-5867.1.patch
>
>
> HiveCLI support the .hiverc script that is executed at the start of the session. This is helpful for things like registering UDFs, session specific configs etc.
> This functionality is missing for beeline and JDBC clients. It would be useful for JDBC driver to support an init script with SQL statements that's automatically executed after connection. The script path can be specified via JDBC connection URL. For example 
> {noformat}
> jdbc:hive2://localhost:10000/default;initScript=/home/user1/scripts/init.sql
> {noformat}
> This can be added to Beeline's command line option like "-i /home/user1/scripts/init.sql"
> To help transition from HiveCLI to Beeline, we can keep the default init script as $HOME/.hiverc



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)