Athan ← 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 Athan commented · Feb 8, 2019 · Delete… Just type the following in the Hive Shell: hive> create database <your database name> > location < '/complete path of the folder you want to save your database' > ; use the command "show databases; " to verify that your database has been created. =) Happy learning fellows! Save Submitting...
Just type the following in the Hive Shell:
hive> create database <your database name>
> location < '/complete path of the folder you want to save your database' > ;
use the command "show databases; " to verify that your database has been created.
=) Happy learning fellows!