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
700 views Asked by elyon At
1
There are 1 answers
Related Questions in HIVE
- Type Adapter for Offset in hive flutter
- HIVE Sql Date conversion
- How to set spark.executor.extraClassPath & spark.driver.extraClassPath in hive query without adding those in hive-site.xml
- Hive query on HUE shows different timestamp than programatically/on data
- descending order of data in hive using collect_set
- How to optimize writing to a large table in Hive/HDFS using Spark
- Spark SQL repartition before insert operation
- Alter datatype of complex type(array<struct>>) in hive
- SqlAlchemy connection to Hive using http thrift transport and basic auth
- Aggregate values into a new column while retaining the old column
- Is it possible to query MAPR hdfs/hive tables from Trino?
- Can we make a column having both partitioning and bucketing in hive?
- converting varchar(7) to decimal (7,5) in hive
- Extract all characters before numeric values in hive SQL
- Livy session to submit pyspark from HDFS
Related Questions in HQL
- How to compare table column to parameter argument using SQL functions with HQL?
- Migrate Oracle SQL query with ROWNUM into PostgreSQL HQL query
- Hibernate query language: Unsuccessful in getting multiple ManyToMany/OneToMany Fields without selecting all unnecessary fields
- HQL unexpected end of subtree
- How to read and execute hql file(hive query) and create pyspark dataframe
- How to maintain history table with append load (only new and updated records to be appended daily)
- I have a problem with Hive MultiSerde Encoding
- CTE usage with Spring Data JPA 3.2 + Hibernate 6.4 Does not work
- Updating from hibernate 5.5.x to Hibernate 6.1.7 generated the incorrect discriminator query
- Mysql Update query notupdating on the first time
- Query execution errors after upgrading spring boot 3.2.0 to 3.2.1 - ORA-00933 - command not properly ended
- Query execution errors after upgrading spring boot 3.2.0 to 3.2.1
- Extracting multiple result with child tables in PostgreSQL and HQL
- SQL statement to log unupdated element from IN clause
- Hibernate : Fetching data based on multiple table data status
Related Questions in DBVISUALIZER
- How to visualize SQL Server database made from ASP.NET Core Web API with DBVisualizer
- Connection Issues with DbVisualizer: Trouble Opening Databases
- PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following - Oracle12c
- How do I round a number to two decimals in SQL commander in DBV?
- How to extract a portion of a URL in PostgreSQL
- Is there a way to import database connections and settings from DBVis to DataGrip?
- GridDB: 10054:TXN_CLIENT_VERSION_NOT_ACCEPTABLE error while trying to connect to GridDB with DBVisualizer using the gridstore-jdbc JDBC driver
- DBVisualizer: Is there a way to adjust how the auto resize feature works on column widths?
- Cannot connect to Redshift using dbVisulizer - SSL error (from Mac OS)
- How to verify SSL Enablement in Netezza Database using a query in client tool like DBVISUALIZER?
- SQL create counter column for duplicate
- Issue with running a DB2 Script from DataStage Job
- How to Bulk Import data from file into Netezza DB?
- Unable to convert string to number on Redshift
- How to insert multiple rows using standalone procedure in dbviz
Related Questions in METASTORE
- Databricks metastore error - Connection reset
- How to build Hive as a service and metastore using docker-compose
- Accessing data from a databricks hive metastore
- Upgrade FAILED! Metastore state would be inconsistent
- Should I create Azure storage & Metastore in the same region?
- How to create a new metastore?
- How can i setup unity catalog in databricks?
- How to connect HIVE Metastore + TRino + S3
- Error while running metastore service on hive using Ubuntu 18.04 LTS
- hive metastore autocreate on spark
- Spark-shell can't access Hive MetaStore
- Using Presto on existing ORC files in S3
- Access Spark Hive metastore within an UDF running in the workers (Databricks)
- Hive error after the command 'show databases;'
- Standalone hive metastore with Iceberg and S3
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?
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)
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.