<div>
I don't know Apache Hive, but from what I read it stores metadata in a different database (Derby by default) you need to connect to separately, at least with 2.3 (<a href="https://stackoverflow.com/questions/20686019/how-to-display-information-schema-using-hive" rel="ugc">https://stackoverflow.com/questions/20686019/how-to-display-information-schema-using-hive</a>). I could not find anything in the release notes of 3.0 about a change.<br />
ain the repository you should have the standard information_schema views available to retrieve table and column info as with other databases.
</div>


I don't know Apache Hive, but from what I read it stores metadata in a different database (Derby by default) you need to connect to separately, at least with 2.3 (https://stackoverflow.com/questions/20686019/how-to-display-information-schema-using-hive [https://stackoverflow.com/questions/20686019/how-to-display-information-schema-using-hive]). I could not find anything in the release notes of 3.0 about a change.
ain the repository you should have the standard information_schema views available to retrieve table and column info as with other databases.

<div>
I'm wondering if your version allows:<br />
<br />

<pre><code id="code-20-42664216-1">SELECT DISTINCT TABLE_NAME 
 FROM INFORMATION_SCHEMA.COLUMNS
 WHERE COLUMN_NAME IN ('columnNameSearch')
     AND TABLE_SCHEMA='YourDatabase';</code></pre>
</div>


I'm wondering if your version allows:



SELECT DISTINCT TABLE_NAME 
 FROM INFORMATION_SCHEMA.COLUMNS
 WHERE COLUMN_NAME IN ('columnNameSearch')
     AND TABLE_SCHEMA='YourDatabase';

Software Solutions Consultant

Marcus Aurelius

<div>
<div class="content wysiwyg-content">
Hive. How can I search for all tables in a database that contain a Column Name?
</div>
</div>


Hive. How can I search for all tables in a database that contain a Column Name?

Hive, How to Search using Column Name for all table in the DB that contain that Column Name?

Big data describes data sets that are so large or complex that traditional data processing applications are inadequate. Challenges include analysis, capture, data curation, search, sharing, storage, transfer, visualization, querying and information privacy. The term often refers simply to the use of predictive analytics or certain other advanced methods to extract value from data, and seldom to a particular size of data set.

Big Data

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.