yes, I am using same active namenode uri *hdfs://active.namenode.com:8020 <http://active.namenode.com:8020>*,for HDFS plugin.
Same thing I used for Hive plugin as well. On 20 November 2015 at 00:27, Andries Engelbrecht <[email protected] > wrote: > Hmmm, I assume you used hdfs://active.namenode.com:8020 <hdfs:// > active.namenode.com:8020> for the DFS connection plugin config. > > Perhaps someone more familiar with the Hive plugin can provide more info. > > --Andries > > > On Nov 18, 2015, at 7:32 PM, Shaik M <[email protected]> wrote: > > > > 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 > >>>> > >> > >> > >
