Hive creating data base

Hi within hive…

hive> create database _retail_db_text;

…shows that permission denied against my user name…

  • I am struggling to perform basic operations -haven’t got long before subscription runs out… admin please sort thanks…

Hi @xyz111,

Please go through the following article.

i am already following udemy HDPCD spark module…

it just says no permission to create the directory… with show database; command i can see that other users’ directories…

Hi @xyz111,

Please go through the following video to understand how to create a database in hive in ITversity labs.

https://www.youtube.com/watch?v=lDOXBXhX0cU&list=PLf0swTFhTI8o5Lb5yw1aDtvVJ8Wo4Lpm-&index=8

Can you please share the screenshot and also the commands you are trying for the error you are facing?

many thanks -I will try it…
Also i had issue with reading file from my local machine…or do i need to use the same folder ‘/user’ with ‘open(…txt).read().splitlines()’ command?.. thanks…

hi i am again getting:
permission denied message…

please sort…

Hi i have managed to understand creating database, table and table schema…
i am following article: ITVersity Big Data Labs — Hive Starter Kits | by Durga Gadiraju | Medium

now when trying to follow:
LOAD DATA LOCAL INPATH ’ /data/retail_db/orders’ INTO TABLE orders;

i am getting stuck…wondering where’s the original table orders which I can fetch data from?.. thanks…

@xyz111 Please refer to the screenshot, I tried in your database and it is working fine for me.