hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andre Araujo <ara...@pythian.com>
Subject Re: DDLTask. Database does not exist:
Date Sun, 22 Jun 2014 09:05:11 GMT
Robert,

check your hive.metastore.uris variable. It seems that your Hive sessions
are using a local derby metastore, which is created in your local directory
by default, instead of using a shared metastore.

Cheers,
Andre



On 22 June 2014 10:57, Grandl Robert <rgrandl@yahoo.com> wrote:

> Ok. It seems if I start hive from the same directory path I used to launch
> tpds script to generate database/input, the database is recognized. If I
> change the current location, then not.
>
> For example:
> hadoop@nectar-11:~/rgrandl/hive/hive-testbench$ ./tpcds-setup.sh 20
> if I launch hive from here, the DB is recognized.
>
> If I do  hadoop@nectar-11:~/rgrandl/hive/hive-testbench$ cd
> sample-queries-tpcds/
> and start hive again, then the DB does not exist.
>
> Any idea why is that ?
>
>
>   On Saturday, June 21, 2014 4:30 PM, Grandl Robert <rgrandl@yahoo.com>
> wrote:
>
>
>  Hi guys,
>
> I have created a database using this link:
> https://github.com/cartershanklin/hive-testbench, which basically creates
> a database: tpcds_bin_partitioned_orc_20.db and input data using TPC-DS
> benchmark.
>
> The database is visible in HDFS under /user/hive/warehouse/
> tpcds_bin_partitioned_orc_20.db,
> but I cannot access it in hive command line.
> hive.metastore.warehouse.dir=/user/hive/warehouse is correctly set, but
> when try to do
> use hive.metastore.warehouse.dir=/user/hive/warehouse it says:
>
> hive> use tpcds_bin_partitioned_orc_20;
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask. Database does not exist:
> tpcds_bin_partitioned_orc_20
>
> However, if I create a database in command line with: create database
> blah, it is accessible both in HDFS and command line for further
> operations.
>
> Can you guys tell me what I am doing wrong ? I have to mention that I have
> just started to play with Hive, and I am not very familiar with it.
>
> Thanks,
> robert
>
>
>


-- 
André Araújo
Big Data Consultant/Solutions Architect
The Pythian Group - Australia - www.pythian.com

Office (calls from within Australia): 1300 366 021 x1270
Office (international): +61 2 8016 7000  x270 *OR* +1 613 565 8696   x1270
Mobile: +61 410 323 559
Fax: +61 2 9805 0544
IM: pythianaraujo @ AIM/MSN/Y! or araujo@pythian.com @ GTalk

“Success is not about standing at the top, it's the steps you leave behind.”
— Iker Pou (rock climber)

-- 


--




Mime
View raw message