Error In-db browse and In-db Write data

Question

Hi everyone,

I am using In-database tools after years using standart tools and fighting to learning as well but facing some issues that I need help:

I did a conection to my hadoop datalake I already tested it and I can see it is ok but whn I try to use the tools In-db Browse and Write save in-db It shows a error message that I am prone to belevie that can be a driver update needed.

Please guys see the attached file and help me with this error.

It shows table not found but it is not possible because I can find it using Hive and even using Alteryx everything run ok but in-db browse and Write save in-db as I told you.

additional infos:

Thanks a lot!

Info: Connect In-DB (1): ODBC Driver version: 03.80

Error: Browse In-DB (2): Error SQLPrepare: [Cloudera][SQLEngine] (31740) Table or view not found: HIVE.Show partitions rt2.rt2_ai6_ccrcbd0_cc_base_cbd01s_001

simonaubert_bd · Answer

Hello @Edu_XGomes

For in-db tools, you must use a select query (or the name of a table/view that alteryx will append with select *). "Show partitions" or show something won't work.

What release of Hive do you use? If >= 3.0 maybe you can use the catalog in order to retrieve these informations.

Best regards,

Simon

Edu_XGomes · Answer

Hi @mceleavey

The conection is ok.

thanks.

Edu_XGomes · Answer

Hi @mceleavey

I realized that when I run "Select * from database" it runs as well but when I try to see the database partitions so I run "Show partitions databse" the error happens so know I am wondering that may show partitions could not be available on Alteryx.... Can it be?

Thanks.