[jira] [Commented] (HIVE-2377) USE database doesn't work when it's first command in session

["Jakob Homan (JIRA)" <ji...@apache.org>]

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

Jakob Homan commented on HIVE-2377:
-----------------------------------

@Marcin what version of Hive are you running against?  On 7, use as the initial command works fine for me:
{noformat}hive> [jhoman@gw ~]$ hive
Hive history file=/hive_query_logs/jhoman/hive_job_log_jhoman_201108152322_635559337.txt
hive> use u_jhoman;
OK
Time taken: 1.968 seconds
hive> show tables;
OK
foo
Time taken: 0.297 seconds{noformat}

> USE database doesn't work when it's first command in session
> ------------------------------------------------------------
>
>                 Key: HIVE-2377
>                 URL: https://issues.apache.org/jira/browse/HIVE-2377
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Marcin Kurczych
>            Priority: Minor
>
> When USE database is run as a first command it has no effect:
> USE database;
> SHOW TABLES;
> // wrong - default database tables
> When run twice it works:
> USE database;
> USE database;
> SHOW TABLES;
> // ok
> When SHOW DATABASES is used before it, it works:
> SHOW DATABASES;
> USE database;
> SHOW TABLES;
> // ok

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira