Member since
04-25-2016
579
Posts
609
Kudos Received
111
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 2939 | 02-12-2020 03:17 PM | |
| 2140 | 08-10-2017 09:42 AM | |
| 12496 | 07-28-2017 03:57 AM | |
| 3444 | 07-19-2017 02:43 AM | |
| 2535 | 07-13-2017 11:42 AM |
06-17-2016
06:29 PM
1 Kudo
@Jan Horton WebHCat orignally named as Templeton is a REST API for HCatalog and related Hadoop components. HCatalog,Sub-‐component of Hive which serve table meta information acrooss hadoop computation engines like mapreduce,pig, hive etc,it sPublic APIs and webservice wrappers for accessing metadata in Hive metastore,WebHCat actully exppose these information through REST webservices. it also allow user to submit(queue) hadoop streamig,hadoop mapreduce,pig and hive job to the cluster but it is not ideal to regular analytical processing as it only queues the job and don't return you a query results. Hiveserver2 is another hive component which is basically a thrift service which support multiple concurrent clients connecting through JDBC/ODBC.ideal for big analytical workload
further to this you can read along https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients
... View more
06-17-2016
05:13 PM
if I understand you correctly,your ask is you are not able to see the updated value (canal=06) from drill query.
... View more
06-17-2016
11:10 AM
2 Kudos
please try this configuration settings to hold the content of usercache for some designated time. <property>
<name>yarn.nodemanager.delete.debug-delay-sec</name>
<value>10000000</value>
</property>
... View more
06-17-2016
11:08 AM
1 Kudo
it seems your spark driver is running with very small heap size, please try increasing the java.driver memory and see if it helps.
... View more
06-16-2016
09:32 AM
can you post 'show create table table_name' here?
... View more
06-16-2016
09:23 AM
can you try with group by TO_DATE(sales_flat_order.created_at) -- considering sales_flat_order as table alias
... View more
06-16-2016
05:53 AM
could you please share your table ddl. how you created the table.
... View more
06-16-2016
05:36 AM
@Vijay Parmar please try this select GET_JSON_OBJECT(json_table.json,'$.Id') from table;
... View more
06-16-2016
05:14 AM
@Sri Bandaru I think there is no direct way to achieve it untill you store metrics somewhere and have query over it. you can poll the RM scheduler REST API (http://<rm http address:port>/ws/v1/cluster/scheduler) and store the target queue usage somewhere and then run query over it.
... View more