Querying MapR DB tables from Drill

-


1. Create a storage plugin for maprDB in drill Web UI

 {
    "type" : "hbase",
     "enabled" : true,
              config" : {
"hbase.table.namespace.mappings" : "*:/tables" #Change the path where you have mapr tables
}
}

 2. Connect to drill

./sqline

!connect jdbc:drill:zk=10.10.71.12:5181
 
sqlline> !connect jdbc:drill:zk=10.10.71.12:5181
scan complete in 406ms
Enter username for jdbc:drill:zk=10.10.71.12:5181: mapr
Enter password for jdbc:drill:zk=10.10.71.12:5181: ****
0: jdbc:drill:zk=10.10.71.12:5181>

3. Change the storage plugin to maprdb (or the name you have given)

 0: jdbc:drill:zk=10.10.71.12:5181> use maprdb;
+-------+-------------------------------------+
|  ok   |               summary               |
+-------+-------------------------------------+
| true  | Default schema changed to [maprdb]  |
+-------+-------------------------------------+
1 row selected (0.352 seconds)
0: jdbc:drill:zk=10.10.71.12:5181>

 4. This should show you the list of tables created

 0: jdbc:drill:zk=10.10.71.12:5181> show tables;
+---------------+-------------+
| TABLE_SCHEMA  | TABLE_NAME  |
+---------------+-------------+
| maprdb        | drilltest   |
| maprdb        | maprtable   |
| maprdb        | maprtbl     |
| maprdb        | maprtsttbl  |
| maprdb        | mytable     |
| maprdb        | wordcount   |
+---------------+-------------+
6 rows selected (0.254 seconds)
0: jdbc:drill:zk=10.10.71.12:5181>
5. 0: jdbc:drill:zk=10.10.71.12:5181> select count(*) from wordcount;
+---------+
| EXPR$0  |
+---------+
| 1000    |
+---------+
1 row selected (0.258 seconds)
0: jdbc:drill:zk=10.10.71.12:5181>

Comments

Post a Comment

Popular posts from this blog

OpenSSL Certificate creations

-
Create Self Signed Certificate Here are the steps involved in creating self signed certificate a) Create a key b) Generate Certificate Sign request .csr c) Sign your certificate (As it is self signed) a) Create a key Create a directory first (to avoid confusions) #mkdir certificates #cd certificates Generate key file #openssl genrsa 1024 > private.key b) Generate Certificate Sign request .csr #openssl req -new -key private.key > certrequest.csr c) Sign your certificate (As it is self Signed) #openssl x509 -in certrequest.csr -out selfsigned.crt -req -signkey private.key -days 365 Here the -days is the number of days denotes the validity of certificate Once after this we can get the certificate as file "selfsigned.crt"
Read more

HTTP Fs Installation

-
Some steps are specific to MapR Cluster. Ignore those steps. 1. Setup Yum repositories for MapR 2. Check for the packages           yum list mapr-httpfs 3. Install ==> yum install mapr-httpfs 4. Configure the core-site.xml and httpfs-site.xml properties to add impersonations                                                 <property>         <name>hadoop.proxyuser.#HTTPFSUSER#.hosts</name>         <value>httpfs-host.foo.com</value>        </property>         <property>             <name>hadoop.proxyuser.#HTTPFSUSER#.groups</name>     ...
Read more