[
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
