l145040 ← Cognitive Class - Support My feedback 1 result found Create database/tables in Hive using ssh to systemt.datascientistworkbench.com 4 votes Vote Vote Vote We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close Vote We’ll send you updates on this idea 6 comments · General » Hands on Labs · Delete… · Admin → How important is this to you? Not at all You must login first! Important You must login first! Critical You must login first! We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close An error occurred while saving the comment l145040 commented · May 19, 2018 · Delete… I have found its solution: By Default hive uses /apps/hive/warehouse for LOCATION First you need to create a directory in HDFS e.g: /user/yourusername/hive/warehouse Now in order to create database your command must be look like: hive> Create database yourdatabasename > Location '/user/yourusername/hive/warehouse' OK Time taken: 0.025 seconds So in order to verify submit below: hive> show databases; Good luck! Save Submitting... l145040 supported this idea · May 19, 2018
l145040
l145040
supported this idea
·
I have found its solution:
By Default hive uses /apps/hive/warehouse for LOCATION
First you need to create a directory in HDFS e.g:
/user/yourusername/hive/warehouse
Now in order to create database your command must be look like:
hive> Create database yourdatabasename
> Location '/user/yourusername/hive/warehouse'
OK
Time taken: 0.025 seconds
So in order to verify submit below:
hive> show databases;
Good luck!