Toad not showing current Hive Table Listing

Toad Data Point 4.3.0.718 (64 bit)

HIVE2.0 Queries

When looking at the hive tables from TDP I am seeing different tables that what are available from the Ambari Hive 2.0 Query listing. I had to remove the connection and re-add it for new tables to show up but there are several which are not showing the correct names.

Why does TDP show a different listing of tables than what is available in Hive 2.0 queries?

HI Sdeterma,

Can you send me a screen shot for reference? you can send to my emai: vincent.hu@quest.com.

HI Sdeterma,

Received you reply, we are checking this case, give some feedback first:

  1. For new added tables cannot shown in TDP table list, you can try TDP’s refresh feature, select one item(table) in the active Hive connection, right click mouse and then try “Refresh Schema” and “Refresh All”, these should let you see the new added tables.

  2. For not showing correct table names issue, maybe it is related to long table name , we need to some test in our QA env, will give you result soon.

Regards,

Vincent

Thank you, I did try to refresh schema and to refresh all but same results are found.

Warm regards,

SD

From: Vincent.Hu [mailto:bounce-VincentHu@toadworld.com]

Sent: Sunday, March 04, 2018 8:27 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] Toad not showing current Hive Table Listing

RE: Toad not showing current Hive Table Listing

Reply by Vincent.Hu

HI Sdeterma,

Received you reply, we are checking this case, give some feedback first:

  1. For new added tables cannot shown in TDP table list, you can try TDP’s refresh feature, select one item(table) in the active Hive connection, right click mouse and then try “Refresh Schema” and “Refresh All”, these should let you see the new added tables.

  2. For not showing correct table names issue, maybe it is related to long table name , we need to some test in our QA env, will give you result soon.

Regards,

Vincent

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point Forum
notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.

----------------------------Disclaimer----------------------------

This email may contain privileged and/or confidential information that

is intended solely for the use of the addressee. If you are not the

intended recipient, you are strictly prohibited from disclosing, copying,

distributing or using any of the information contained in the transmission.

If you received this communication in error, please contact the sender

(“Company”) immediately and destroy the material in its entirety,

including all electronic and hard copies.

This communication may contain nonpublic personal information about

consumers which is subject to restrictions under the Gramm-Leach-Bliley

Act and the Sarbanes-Oxley Act. You may not directly or indirectly reuse

or disclose such nonpublic personal information for any purpose other than

to provide the services for which you are receiving the information.

There are risks associated with the use of electronic transmission. The

sender of this information does not control the method of transmittal or

any service providers and the sender assumes no duty, liability, or

obligation for the security, receipt, or any third party interception of

this transmission.

The Company reserves the right to amend statements made herein in the event

of a mistake. Unless expressly stated herein to the contrary, only agreements

in writing signed by an authorized officer of the Company may be enforced

against it.

I understand this issue has to do with long names on a Hive table. I have entered QAT-12497 for this issue

Thank you Debbie. How can I track the status of this bug fix?

We don’t have any public facing ticket update system. You can ask for a periodic update on the forum. I scheduled this fix for TDP 4.5 etc june 2018.