Member since
12-14-2015
45
Posts
20
Kudos Received
5
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1420 | 05-03-2016 02:27 PM | |
1342 | 04-27-2016 02:22 PM | |
29121 | 04-27-2016 08:00 AM | |
1385 | 04-21-2016 02:29 PM | |
5571 | 02-03-2016 08:24 AM |
04-02-2020
01:52 AM
You can try logging into the admin user and restart datanodes from the actions bar in Dashboard. That worked for me. May work for you too.
... View more
05-12-2016
12:33 PM
@Ana Gillan @Sagar Shimpi Thanks, got partial resolution. Ranger Hive plugin applies only to Hiveserver2 and not to CLI. But in below mentioned hive table file, how user mktg1 is able to query it using HIVE CLI? [hive@sandbox ~]$ hadoop fs -ls /apps/hive/warehouse/xademo.db/customer_details/acct.txt ---------- 3 hive hdfs 1532 2016-03-14 14:52 /apps/hive/warehouse/xademo.db/customer_details/acct.txt [mktg1@sandbox ~]$ hive hive> use xademo;
OK
Time taken: 1.737 seconds hive> select * from customer_details limit 10; OK PHONE_NUM PLAN REC_DATE STAUS BALANCE IMEI REGION
5553947406 6290 20130328 31 0 012565003040464 R06
7622112093 2316 20120625 21 28 359896046017644 R02
5092111043 6389 20120610 21 293 012974008373781 R06
9392254909 4002 20110611 21 178 357004045763373 R04
7783343634 2276 20121214 31 0 354643051707734 R02
5534292073 6389 20120223 31 83 359896040168211 R06
9227087403 4096 20081010 31 35 356927012514661 R04
9226203167 4060 20060527 21 450 010589003666377 R04
9221154050 4107 20100811 31 3 358665019197977 R04
Time taken: 6.467 seconds, Fetched: 10 row(s)
... View more
05-04-2016
10:41 AM
Yes after change the password complexity its successfully installed ...Thank u
... View more
04-29-2016
01:56 PM
1 Kudo
It may be https://issues.apache.org/jira/browse/AMBARI-15235
... View more
05-02-2016
07:26 AM
Thanks for your reply @bpreachuk I have exactly the behavior you wrote. I checked into the hive-site.xml file (that I specified in my workflow ==> <job-xml>) and the settings was good.
<property>
<name>fs.hdfs.impl.disable.cache</name>
<value>false</value>
</property> I also specified in my HQL script "SET fs.hdfs.impl.disable.cache =
false;" ( I don't know if I can..) but I still have this distcp job. Maybe oozie use another hive-site.xml ?
... View more
04-21-2016
02:29 PM
3 Kudos
You need use sqoop for direct import on hive form sql. First download sql jdbc
https://www.microsoft.com/en-us/download/details.aspx?id=11774 place jar on sqoop master server:
/usr/hdp/current/sqoop-server/lib use this command for import: import --connect jdbc:sqlserver://[SQL_SERVER_NAME]:[SQL_PORT]/[DB-NAME] --username "[SQL_USERNAME]" --password "[PASSWORD]" --query '[INSERT QUERY HERE] WHERE $CONDITIONS' -m 1 --hive-import --hive-database [DB_HIVE] --create-hive-table --hive-table [HIVE_TABLE]
if use --query you must have WHERE $CONDITIONS on query.
... View more
03-18-2016
10:25 AM
hadoop-annotations-2.7.1.2.3.4.0-3485.jar
hadoop-auth-2.7.1.2.3.4.0-3485.jar
hadoop-aws-2.7.1.2.3.4.0-3485.jar
hadoop-azure-2.7.1.2.3.4.0-3485.jar
hadoop-common-2.7.1.2.3.4.0-3485-tests.jar
hadoop-common-2.7.1.2.3.4.0-3485.jar
hadoop-nfs-2.7.1.2.3.4.0-3485.jar Double check it's a classes from Azure.. also you need to add hadoop-hdfs.jar and core-site.xml
... View more
08-04-2016
09:52 AM
Thanks, this solution worked after I did the solution of @Alessio Ubaldi
... View more
02-02-2017
01:52 AM
Can you also post the time taken to execute the 20 mi records? thnx !
... View more