Error while sending command on Hive

[Damanjit_Singh_Bambr]

Dear team I am facing the issue while sending command on web-console for Hive as below , Will appreciate if you can advise to to sort out the issue.

[satyajit_das]

Hi, Damanjit.

You need to first select the database where you need to create the table.
You are directly creating the table. so it will showing the message of the already created table in Hive.

do the below steps.

1. use damanjit20028879; -> select your DB.
2. create the table. “tweets_sentiment”.
   

All the best!

[Damanjit_Singh_Bambr]

Dear Satyajit,
I tried as advised both in web console and Hive, But still I am getting error while creating table please check below both the screen shots.

Please advise me I am stuck on this, will appreciate your prompt reply.

Damanjit Singh

[Damanjit_Singh_Bambr]

Dear Satyajit,
I tried as advised both in web console and Hive, But still I am getting error while creating table please check below both the screen shots.

Please advise me ahead, Am stuck on this.

Damanjit Singh

[abhinav]

Hi @Damanjit_Singh_Bambr,

It is throwing error that table “l3” does not exists.

Could you please check if you have created “l3” table.

Thanks,
Abhinav

[satyajit_das]

Hi, Damanjit.

I see that you have not completed the topic 9 where you have to create the table we will create l1 , l2 , and l3views,
Kindly complete this exercise then you can do the rest.

https://cloudxlab.com/assessment/displayslide/334/hive-project-sentiment-analysis-step-6?course_id=73&playlist_id=345

All the best!

[Damanjit_Singh_Bambr]

Hi,
I am not able to log in to Hue, and I tried to create tweets_sentiment table on web console, but still I am getting error, please advise me step by step so i can sort out this and move ahead.

[satyajit_das]

As per the warning message you have already created the table “tweets_sentiment”.
You are trying to create the table again.
check by show tables; command in hive.