Re: Writing to the connected data source?

2017-08-12 Thread Padma Penumarthy
Workspaces are supported only for file system based storage plugins (DFS, S3). You can create tables in workspaces, by configuring workspaces as writable. Table can be created as file(s) of type parquet, json, psv, csv and tsv, based on configuration option “store.format". For Mongo, creating

Writing to the connected data source?

2017-08-12 Thread Akshat Jiwan Sharma
Hello Everyone, My use case is that I'd like to be able to use Drill as a proxy for my data sources, not only for querying the data but also for writing the data. Is it possible to write data to the connected data store using apache drill rest api? Or perhaps with a custom function

Re: Drill on secure HDFS

2017-08-12 Thread Padma Penumarthy
Did you look at this ? https://drill.apache.org/docs/configuring-kerberos-authentication/ Also, this JIRA has some details. https://issues.apache.org/jira/browse/DRILL-3584 Thanks, Padma On Aug 12, 2017, at 5:04 AM, Ascot Moss > wrote: Does

Error: SYSTEM ERROR: IOException: Can't get Master Kerberos principal for use as renewer

2017-08-12 Thread Ascot Moss
Hi, I use Drill 1.11 on Hive 2.1.1 on Hadoop 2.7.2 with Kerberos. sqlline -u "jdbc:drill:drillbit=n1.server:31010;auth=kerberos;principal=drill/server" -n "drill/n1.server" use hive; +---+---+ | ok | summary |

Error: SYSTEM ERROR: IOException: Can't get Master Kerberos principal for use as renewer

2017-08-12 Thread Ascot Moss
Hi, I use Drill 1.11 on Hive 2.1.1 on Hadoop 2.7.2 with Kerberos. sqlline -u "jdbc:drill:drillbit=n1.server:31010;auth=kerberos;principal=drill/server" -n "drill/n1.server " use hive; +---+---+ | ok | summary |

Re: Drill on secure HDFS

2017-08-12 Thread Ascot Moss
Does Drill's File Storage Plugin (DFS Plugin) support Hadoop-Kerberos? I cannot find any link about this. https://drill.apache.org/docs/file-system-storage-plugin/ This document does not provide to much detail about whether Drill supports Hadoop-Kerberos or not. On Sat, Aug 12, 2017 at 4:09 PM,

Re: Drills' Hbase storage plugin

2017-08-12 Thread Ascot Moss
Does Drill's Hbase Storage support Hbase-Kerberos? I cannot find any link about this. https://drill.apache.org/docs/hbase-storage-plugin/ This link does not provide too much detail about Drills' Hbase Storage on HBase-Kerberos. On Sat, Aug 12, 2017 at 4:11 PM, Ascot Moss

Re: Drill UI (8047) Default User and Password

2017-08-12 Thread Ascot Moss
Thanks! By the way, how to configure hbase plugin to query kerberos-hbase? On Fri, Aug 11, 2017 at 1:38 PM, Sorabh Hamirwasia wrote: > To add on Arina's reply: > > > Authentication on WebServer side happens using PLAIN mechanism with PAM > authenticator. So when

Drills' Hbase storage plugin

2017-08-12 Thread Ascot Moss
Hi, I have Hbase with Kerberos enabled, how to configure drill's hbase storage plugin in order to access kerberos-Hbase? Regards

Drill on secure HDFS

2017-08-12 Thread Ascot Moss
Hi, I have HDFS with Kerberos enabled, how to configure drill's dfs plugin in order to enable Kerberos authentication? regards