Impala实践之六:使用Rest Api

JerryXia 发表于 , 阅读 (23)

前言

上次的impala状况出现后,决定自己做一套impala的管理系统,那么首先面临的一个问题就是获取impala的各种状态,比如任务执行状态。经过一天多的尝试,总结一下。

  • hue:可以使用hue的脚本,hue使用python编写,其中有一个beeswax模块,负责任务的执行等。缺点是没发现java的api。
  • cloudera manager java api:java可以调用cm原生的api,需要导入jar包。跑是跑通了,但是资料太说,目前只能通过这个接口获取集群的基本情况,不想再折腾impala那快了。
  • cloudera manager 的api:cm提供了rest的api供别人调用,经过接近一天的折腾,跑通了这一块。

Cloudera Manager API

impala相关

和impala相关的api有下面这几个,能用上的主要是最下面带queries的几个接口:

  • /clusters/{clusterName}/services/{serviceName}/commands/hueSyncDb
  • /clusters/{clusterName}/services/{serviceName}/commands/impalaCreateCatalogDatabase
  • /clusters/{clusterName}/services/{serviceName}/commands/impalaCreateCatalogDatabaseTables
  • /clusters/{clusterName}/services/{serviceName}/commands/impalaCreateUserDir
  • /clusters/{clusterName}/services/{serviceName}/commands/impalaDisableLlamaHa
  • /clusters/{clusterName}/services/{serviceName}/commands/impalaDisableLlamaRm
  • /clusters/{clusterName}/services/{serviceName}/commands/impalaEnableLlamaHa
  • /clusters/{clusterName}/services/{serviceName}/commands/impalaEnableLlamaRm
  • /clusters/{clusterName}/services/{serviceName}/impalaQueries
  • /clusters/{clusterName}/services/{serviceName}/impalaQueries/{queryId}
  • /clusters/{clusterName}/services/{serviceName}/impalaQueries/{queryId}/cancel
  • /clusters/{clusterName}/services/{serviceName}/impalaQueries/attributes

调用示例

接口说明:

GET

Returns details about the query. Not all queries have details, check the detailsAvailable field from the getQueries response.

/api/v9/clusters/{clusterName}/services/{serviceName}/impalaQueries/{queryId}

注意:

  1. username:password:是指登录cm的账号和密码
  2. Cluster1:是你的集群的名字
  3. impala:是你的impala服务的名字
  4. 364e76f05cdffsdf802b0:3a499cc3fb86bf8afsd: 是query的id

curl例子:

curl -u username:password 'clouderamanager.zhdd.com/api/v9/clusters/Cluster1/services/impala/impalaQueries/364e76f05cdffsdf802b0:3a499cc3fb86bf8afsd'

结果:

结果是一个大的json串

java示例:

import org.apache.http.auth.AuthScope;import org.apache.http.auth.UsernamePasswordCredentials;import org.apache.http.client.CredentialsProvider;import org.apache.http.client.methods.CloseableHttpResponse;import org.apache.http.client.methods.HttpGet;import org.apache.http.client.methods.HttpPost;import org.apache.http.impl.client.BasicCredentialsProvider;import org.apache.http.impl.client.CloseableHttpClient;import org.apache.http.impl.client.HttpClients;import org.apache.http.util.EntityUtils;public class ClientAuthentication {    public static void main(String[] args) throws Exception {        String username = "username";        String password = "password";        CredentialsProvider credsProvider = new BasicCredentialsProvider();        credsProvider.setCredentials(                new AuthScope("clouderamanager.zhdd.com", AuthScope.ANY_PORT),                new UsernamePasswordCredentials(username, password));        CloseableHttpClient httpclient = HttpClients.custom()                .setDefaultCredentialsProvider(credsProvider)                .build();        try {            HttpGet httpget = new HttpGet("http://clouderamanager.zhdd.com/api/v9/clusters/Cluster1/services/impala/impalaQueries/364e76f05cdffsdf802b0:3a499cc3fb86bf8afsd");            System.out.println("Executing request " + httpget.getRequestLine());            CloseableHttpResponse response = httpclient.execute(httpget);            try {                System.out.println("----------------------------------------");                System.out.println(response.getStatusLine());                System.out.println(EntityUtils.toString(response.getEntity()));            } finally {                response.close();            }        } finally {            httpclient.close();        }