About aliyesami

aliyesami · ‎10-02-2018

anyone ?

aliyesami · ‎10-01-2018

i can map a hive table to elasticsearch by specifying a elasticsearch storage handler , but can i map an elasticsearch index to an existing hive table? can that table be ORC, partitioned n bucketed ? any examples would do

aliyesami · ‎09-30-2018

I know how to create these UDFs from command prompt but how do I create these functions from ambari view? is there any document example explaining this ?

aliyesami · ‎09-26-2018

I could resolve this issue by modifying the following parameters yarn.scheduler.minimum-allocation-mb=2560 yarn.nodemanager.resource.memory-mb=7680 yarn.app.mapreduce.am.resource.mb=2560

aliyesami · ‎09-25-2018

if i insert a row from hive command line in unix it starts a TEZ job and runs fine and inserts a row, but the same insert if i try to do from hive view in Ambari, it hangs. The SELECT queries work fine in hive view . plz see the attached screenshots

aliyesami · ‎09-25-2018

you were absolutely right .. . it was the proxy settings causing . I removed the proxy settings from ambari-server and bounced it and all views working now . I tried to append the -Dhttp.nonProxyHosts=hadoop1|hadoop2|hadoop3 to the proxy settings of ambari \but it didn't like it .. can you give me right syntax please ?

aliyesami · ‎09-25-2018

yes i am behind proxy but only for outgoing calls , hive view should not try to go outside my cluster right? Ambari is elready enabled for proxy and working fine. All the modules like hive, hbase, curl, yum, etc etc working fine so why would i have just issue with ambari views? none of them work .

aliyesami · ‎09-24-2018

Ambari server log showing the following: 24 Sep 2018 17:35:20,856 ERROR [ambari-client-thread-199385] WebHdfsFileSystem:402 - Unable to get HomeDirectory from original File System java.io.IOException: hadoop1.tolls.dot.state.fl.us:50070: Unexpected HTTP response: code=504 != 200, op=GETHOMEDIRECTORY, message=Gateway Timeout if i press the back arrow button it does show me the hive command window but if i give any command there i get this error :

aliyesami · ‎09-24-2018

I am trying to setup HIVE view for ambari users but its not working its not giving any specific error also but this is what i see . I am not using Kerberos. I have the /user/admin directory and proxy parameters set. $ hdfs dfs -ls /user/Found 13 items drwxr-xr-x - admin hadoop 0 2018-08-20 17:27 /user/admin hadoop.proxyuser.root.groups=*hadoop.proxyuser.root.hosts=* Issues detected Service 'userhome' check failed: hadoop1.tolls.dot.state.fl.us:50070: Unexpected HTTP response: code=504 != 200, op=GETFILESTATUS, message=Gateway Timeout

aliyesami · ‎09-23-2018

I just noted there is a small note on top saying " Note This procedure requires change data capture from the operational database that has a primary key and modified date field where you pulled the records from since the last update. we don't have CDC on our database so we cant do incremental imports? it should be possible by looking at the date field as that's constantly increasing ?

Online	Offline
Last Visited	‎11-03-2016 03:37 PM

Member Since	‎04-22-2016 08:38 AM
Last Visited	‎11-03-2016 03:37 PM
Posts	931
Kudos received	46

Cloudera Community

Re: NON-ANSI JOIN in hive

Re: insert query hangs from hive view ONLY

Re: cant start rest server

Re: hbase rest api failing

Re: how to read time reported by yarn

Re: creating UDFs from ambari view

mapping elasticsearch to hive

creating UDFs from ambari view

Re: insert query hangs from hive view ONLY

insert query hangs from hive view ONLY

Re: HIVE services check failing

Re: HIVE services check failing

Re: HIVE services check failing

HIVE services check failing

Re: 5th attempt at getting an answer to this quest...