Toad World® Forums

Not able to view Hive table with Avro file format

I have created table in hive stored in avro format, not able to view the data/metadata from Toad Data Point 4.3. I am able to see the table in object explorer. I am using Apache Hive connection and able to see other basic tables and also view data

See below error on select query.

error:
Can't find database object 'XXXXX'

Hi,
could it be caused by having inadequate permissions to this object? Did you create this table using Toad?

Toad Hive connectivity is read only. I created the table in Apache Hive in hadoop env.
I am also using same userid in toad as i have created in hive.

I see you've opened up a support case. Let's deal with it there. Thanks.

Toad Data Point Hive connector do support table data stored in 'avro' file format, it should be something about the env/data. We are checking it now.

Hi , Please try to remove this hive connection and create a new hive connection .
Then query this table again .

Thanks. I had to specify the Avro schema location and refreshed the connection and it worked.