question Re: Hive Tables not visible in data analytics Studio in Support Questions

Hive Tables not visible in data analytics Studio

shashank_naresh — Sat, 24 Aug 2019 15:52:41 GMT

Hi,

I am facing an issue:

hive table created in data analytics studio is not listed under tables (refer below screen print, tables listed under "Search Tables" text box)

But when doing select that table is shown in results (refer below screen print, under results)

Could you please let me know what is the issue here and how it can be corrected.

More information - I am using HDP 3.0 sandbox with CDA enabled.

Re: Hive Tables not visible in data analytics Studio

cravani — Sun, 25 Aug 2019 19:11:16 GMT

Do you see any errors in /var/log/das/das-webapp.log? This log file would be on das-webapp host if possible please attach the file to the thread.

Re: Hive Tables not visible in data analytics Studio

shashank_naresh — Tue, 03 Sep 2019 16:58:57 GMT

Hi,

I am not seeing any error in /var/log/das/das-webapp.log.

Re: Hive Tables not visible in data analytics Studio

hiveravids2 — Wed, 04 Sep 2019 12:12:27 GMT

I have encountered a similar scenario, just refreshing the page and reopenings the page helped in showing the table in Data Analytics Studio.

Re: Hive Tables not visible in data analytics Studio

shashank_naresh — Sun, 10 Nov 2019 06:48:21 GMT

Hi cloudera Team,

Following up for this issue;

Re: Hive Tables not visible in data analytics Studio

KWiseman — Sun, 24 Nov 2019 19:27:14 GMT

has there been any resolution? I am in a similar situation. This has been an ongoing issue with the hortonworks sandbox that has spanned a couple of computers and works fine on another and I have no idea as for why. I followed as many different offerings for fixes like checking the hive event listeners and everything seems to be in order.

Any help would be appreciated.

Re: Hive Tables not visible in data analytics Studio

Shelton — Sun, 24 Nov 2019 19:47:19 GMT

@shashank_naresh @KWiseman

I have responded to this issue before can you have a look at the thread

https://community.cloudera.com/t5/Support-Questions/DAS-Database-Empty/m-p/238223#M200034

Please let me know if you need more clarification, I have attached 2 pdf's to walk you through the solution.
Happy hadooping

Re: Hive Tables not visible in data analytics Studio

KWiseman — Sun, 24 Nov 2019 21:26:44 GMT

As odd as it may be, I am able to create tables using the method you describe, and i'm able to upload tables as well - that is not really my issue. My issue lies with creating the tables with hive. I want to be able to write a query that creates a table instead of creating one using the the database screen.

For example, if I go to compose and I write:

CREATE TABLE temp_drivers (col_value STRING)

the table is created, I know this because I can see it when I run SHOW TABLES. But it does not show itself alongside the other tables that were created in the database using the GUI on the database screen.

Re: Hive Tables not visible in data analytics Studio

shashank_naresh — Mon, 25 Nov 2019 18:44:01 GMT

@KWiseman

Agreed, I did not have any other option to re-install HDP.

Re: Hive Tables not visible in data analytics Studio

shashank_naresh — Fri, 20 Mar 2020 03:35:59 GMT

Hi @Shelton

Reason of this issue is

https://docs.cloudera.com/HDPDocuments/DAS/DAS-1.4.4/troubleshooting/content/das_replication_failure_in_event_processor.html

That I validated at my end, /var/log/das/event-processor.log is showing "Notification events are missing in the meta store" and /var/log/das/event-processor.log is showing replication is unsuccessful.

I tried to follow instructions mentioned in above link to submit command

curl -H 'X-Requested-By: das' -H 'Cookie: JSESSIONID=<session id cookie>' http(s)://<hostname>:<port>/api/replicationDump/reset

please refer screen print attached

This command did not work, showing;

{"code":404,"message": "HTTP 404 Not Found"}

Could you please help here.

Re: Hive Tables not visible in data analytics Studio

shashank_naresh — Sun, 31 May 2020 16:18:37 GMT

Hi @Shelton ,

Was you get chance to look into this issue, needed help on this.

Thanks