Hi Gurus,
I want to access remote hive metastore on mapr : Below are the conf parameters:
driver :"org.apache.hive.jdbc.HiveDriver"
database url : jdbc:hive2://Company.com:port number/
I am using hiveserver2 and dbvisualizer is the tool from where i fire queries . I want to access this remote hive metastore and be able to get date of creation of tables which are more than N days old . Please tell me how it can be done and the hive query for the same. I have a jdbc code which does the same ,but i would like to know if i can directly write a hive query to do the same.Does hcatalog provide a way to do this and if so how ?
Query remote hive metastore to get list of tables
696 Views Asked by elyon At
1
There are 1 best solutions below
Related Questions in HIVE
- How do I set the Hive user to something different than the Spark user from within a Spark program?
- schedule and automate sqoop import/export tasks
- PIG merge two lines in the log
- Elephant bird with hive to query protobuf file
- How can we decide the total no. of buckets for a hive table
- How to create a table in Hive with a column of data type array<map<string, string>>
- How to find number of unique connection using hive/pig
- sqoop-export is failing when I have \N as data
- How can we test expressions in hive
- Run Hive Query in R with Config
- Rhive: The messages shows: Not Connected to Hiveserver2 (But can connect HDFS)
- HIVE Query Deleting source data blob
- Hive JOIN of query with subquery takes forever
- What is Metadata DB Derby?
- How could I set the number or size of output files in an "insert" script?
Related Questions in HQL
- How to perform left join in hql to fetch data
- What is the equivalent HQL query for this SQL query (fetch max value from Inner Join)
- How to pass parameter in HQL query
- Joins in Hibernate : HQL equivalent of given SQL
- Select from Table Valued Function nhibernate
- Hibernate hql/criteria result contains collection
- Hibernate aliasToBean with field collection
- HQL count() with group by not returning zero/0 records
- Hibernate delete by criteria error
- unexpected token : ( subquery hql
- How to join 2 entities based on NOT condition
- HQL to access the subclass object of @manytoOne fields
- HQL order by expression
- join 2 columns and get only matched vlaues in hibernate
- Whats the correct way to use HQL for data with delete flags
Related Questions in DBVISUALIZER
- Applying dual conditions in case when in MYSQL
- Create a temp table from a select query -- dbVisualizer vs SQL Developer
- ORA-12514 error on **DBVisualizer**
- How to access *.mv.db file of H2 database?
- Why does vsql can return all the records, while program using ODBC driver can't?
- DBVisualizer Fails to Connect
- DB2 declared temporary table varchar returns error -443
- DBVisualizer query snytax to add a range of values
- How to execute a procedure from SQL Commander which has refcursor as a out parameter in db-visulizer
- How to resolve ORA-01489: result of string concatenation is too long
- Error in concatenation of `LISTAGG` function[Not a duplicate question]
- DBVisualizer displays null on date field holding '0001-01-01'
- DBvisualizer 9.1.12 errors on semicolon in comments
- Query remote hive metastore to get list of tables
- CRUD processing with access controls to SQL Server database
Related Questions in METASTORE
- What is the metastore for in Spark?
- Spark making a local metastore instead of storing the data in the actual mysql metastore
- Hive Accumulo Integration
- Cloudera/Hive - Can't access tables after hostname change
- Standalone hive metastore with Iceberg and S3
- Can't start hive, some error with hive-metastore-server
- Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
- Query remote hive metastore to get list of tables
- Databricks metastore error - Connection reset
- Hive error after the command 'show databases;'
- Error while running metastore service on hive using Ubuntu 18.04 LTS
- Access Spark Hive metastore within an UDF running in the workers (Databricks)
- Using Presto on existing ORC files in S3
- How can i setup unity catalog in databricks?
- How to fix if indexes are corrupted in hive metastore. and Partitions table is throwing errors
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You mentioned using jdbc code to obtain your specific query results. That is the correct way. Hive supports the following syntaxes, which are relatively simple/limited versus full fledged sql that you can do via jdbc:
It is not possible to run a full fledged query with filtering and ordering as you had done in jdbc.