AnsweredAssumed Answered

Access remote hive metastore using hive query

Question asked by ankit on Dec 4, 2014
Latest reply on Jan 7, 2015 by fwilckens
> Hi All,
> I want to access remote hive metastore
> on mapr : Below are the conf parameters:
> driver  :"org.apache.hive.jdbc.HiveDriver"
> database url : jdbc:hive2:// 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.
> Also as i am new to hive some useful links would be a good reference to start