Hi Andries,
Thank you for your reply.
DFS plugin working fine, I can able to query the data from HDFS.
SELECT * FROM `dfs`.`root`.`tmp/yahoo_stocks.csv` LIMIT 100.
Issue with Hive Plugin only. Below are my Hive Plugin conf...
{
"type": "hive",
"enabled": true,
"configProps": {
"hive.metastore.uris": "thrift://meta.hive.com:9083",
"hive.metastore.warehouse.dir": "/apps/hive/warehouse",
"fs.default.name": "hdfs://active.namenode.com:8020",
"hive.metastore.sasl.enabled": "false",
"hive.server2.enable.doAs": "true",
"hive.metastore.execute.setugi": "true"
}
}
I have given here active Namenode Hostname, but when i try to query hive
data, it is looking for NN HA uri *(**bdp-lab-hadoop**)*. and showing
exception unable to find hostname.
As I aware Drill wont able to find/support NN HA logical URI. I have
trying to trace the issue, but not able :(.
I am not understanding, why it is looking beyond the conf?
Please help to fix this.
Thanks.
On 19 November 2015 at 00:25, Andries Engelbrecht <[email protected]
> wrote:
> Have you configured just a DFS plugin to see if you can read from HDFS
> directly before configuring the Hive plugin?
>
> Also it may be good to double check your network config on all the nodes
> due to this SYSTEM ERROR: UnknownHostException: bdp-lab-hadoop
>
> --Andries
>
>
>
> > On Nov 18, 2015, at 6:31 AM, Shaik M <[email protected]> wrote:
> >
> > Team, Please let me to resolve this issue.
> >
> > On 17 November 2015 at 23:10, Shaik M <[email protected]> wrote:
> >
> >> Hi Team,
> >>
> >> I am new to Drill, I have installed Apache Drill one of my Hadoop
> >> environment on 3 datanodes.
> >>
> >> We have enable NameNode HA. And I have configured storage plugins of
> HDFS
> >> and Hive.
> >>
> >> I have given "fs.default.name": "hdfs://active.namenode:8020" in hive
> >> plugin. but when I tried to query hive data it is picking NN HA uri and
> >> its failing with following exception.
> >>
> >> 0: jdbc:drill:drillbit=localhost> select * from test_data limit 10;
> >> Error: SYSTEM ERROR: UnknownHostException: bdp-lab-hadoop
> >>
> >>
> >> [Error Id: c6e69561-89af-4d98-9909-82f332437bba on hostname.com:31010]
> >> (state=,code=0)
> >>
> >> Please help me to fix this issue.
> >>
> >> Thanks,
> >> Shaik
> >>
>
>
