About rajkumar_singh

rajkumar_singh · ‎06-07-2016

@nyadav not much popular but hive has storage handler for mongodb and cassandra https://github.com/mongodb/mongo-hadoop/wiki/Hive-Usage https://github.com/tuplejump/cash/tree/master/cassandra-handler

rajkumar_singh · ‎06-07-2016

@Roberto Sancho There is a distinction between table metadata and table data. table metadata is stored in hive metastore.if you want to cache the hive meta into drill then for defined hive.metastore.cache-ttl-seconds your meta data will be cache. you are able to see the new inserted data into the table until you alter the table. as soon as you alter the table your metastore will be updated with the new table structure but your drill cache will have old entries only and you will not see new table data.

rajkumar_singh · ‎06-07-2016

@nyadav no Hive don't have capability to query other data source until its storage handler is defined. hive has concept of native and non native tables, for native tables it know how to manage it but for non native table it dont have a capability until it has not storage handler. to know more of storage handler you can refer this doc https://cwiki.apache.org/confluence/display/Hive/StorageHandlers

rajkumar_singh · ‎06-07-2016

@Roberto Sancho yes, please change the table DDL and use insert overwrite to insert the data again.

rajkumar_singh · ‎06-07-2016

@Roberto Sancho the configuration looks gud,if you want to cache hive meta for longer period of time you can increase the hive.metastore.cache-ttl-seconds value.

rajkumar_singh · ‎06-06-2016

@Hemalatha Panneerselvam is this what you looking for SELECT count(col_name) FROM table where col_name like '%http%' having count(col_name) >=3

rajkumar_singh · ‎06-06-2016

if your external table is pointing to some location in hdfs and you are putting more csv data on table location which has same schema as of defined table then hive will take care of new data automatically.

rajkumar_singh · ‎06-06-2016

I will suggest you to try nifi PutHDFS, more on this you can find here https://community.hortonworks.com/articles/7999/apache-nifi-part-1-introduction.html

rajkumar_singh · ‎06-05-2016

@Roberto Sancho I could not get your question here, could you please elobarate what you are asking?

rajkumar_singh · ‎06-05-2016

it looks that atlas hook is enabled in your sandbox, could you please check your hive-site.xml change hive.exec.post.hooks as follows if you dont want to use atlas hooks from <property> <name>hive.exec.post.hooks</name> <value>org.apache.hadoop.hive.ql.hooks.ATSHook, org.apache.atlas.hive.hook.HiveHook</value> </property> to <property> <name>hive.exec.post.hooks</name> <value>org.apache.hadoop.hive.ql.hooks.ATSHook</value> </property>

Online	Offline
Last Visited	‎08-23-2021 03:30 PM

Member Since	‎04-25-2016 07:57 AM
Last Visited	‎08-23-2021 03:30 PM
Posts	579
Kudos received	568

Cloudera Community

Re: Why Hive Compaction is failing ?

Re: how to setup queue name for squirrel

Re: How to set the logging level of the hiveserver...

Re: Hive Tez Client Memory

Re: Resource Manager API ?

Re: Does hive supports query from multiple sources...

Re: apache drill queries

Re: Does hive supports query from multiple sources...

Re: slow query in hive

Re: apache drill queries

Re: I have a column which has tweet data some of i...

Re: external tables in Hive

Re: Load terabytes of data from Local system to ...

Re: slow query in hive

Re: Flume Hive sink error