Error In-db browse and In-db Write data

[Edu_XGomes]

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

[mceleavey]

Hi @Edu_XGomes ,

Yes, this could be a driver error, or it could be that if you can connect using the standard tools but receive an error when using the In-DB tools that the remote platform does not support In-DB.

Check you can connect with the standard Alteryx tools first, that should narrow down the problem.

M.

[mceleavey]

@Edu_XGomes ,

also, the connection string contains HIVE. Is this correct? Don't just copy the connection from HIVE or you will get the error.

[Edu_XGomes]

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.

[Edu_XGomes]

Hi @mceleavey 

The conection is ok.

thanks.

[simonaubert_bd]

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