I tried running the command: pig -x tez -useHCatalog Pigscript but there result is the same. It's saying : 2016-02-24 23:04:54,675 [main] ERROR org.apache.pig.Main - ERROR 2997: Encountered IOException. File –useHCatalog does not exist Details at logfile: /hadoop/yarn/local/usercache/ppunj/appcache/application_1456334730705_0001/container_e05_1456334730705_0001_01_000002/pig_1456355093669.log 2016-02-24 23:04:54,722 [main] INFO org.apache.pig.Main - Pig script completed in 1 second and 467 milliseconds (1467 ms) ... View more

@Neeraj Sabharwal - I managed to install Ranger now. THanks ... View more

@Neeraj Sabharwal. Looks like Ranger is failing to install because of the error below. I am using MySql db. what is the root user. Looks at the screen shot.. 2016-02-24 03:52:25,732 [I] ---------- Creating Ranger Admin db user ---------- 2016-02-24 03:52:25,732 [JISQL] /usr/jdk64/jdk1.8.0_60/bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://hdp-m.asotc/mysql -u rangeradmin -p '********' -noheader -trim -c \; -query "SELECT version();" SQLException : SQL state: 28000 java.sql.SQLException: Access denied for user 'rangeradmin'@'hdp-m.asotc' (using password: YES) ErrorCode: 1045 ... View more

@Neeraj Sabharwal Looks like I had mysql, so I am using instruction for MySql and installing Ranger. Hopefully this will go smooth... ... View more

Thanks @Neeraj Sabharwal and @Saurabh Kumar. I think it would be helpful to identify users and their jobs running. May be in future release of Ambari.. ... View more

@Artem Ervits Below is the code that I m using in pig script. a = LOAD 'geolocation' using org.apache.hive.hcatalog.pig.HCatLoader(); b = filter a by event != 'normal'; c = foreach b generate driverid, event, (int) '1' as occurance; d = group c by driverid; e = foreach d generate group as driverid, SUM(c.occurance) as t_occ; g = LOAD 'drivermileage' using org.apache.hive.hcatalog.pig.HCatLoader(); h = join e by driverid, g by driverid; final_data = foreach h generate $0 as driverid, $1 as events, $3 as totmiles, (float) $3/$1 as riskfactor; store final_data into 'riskfactor' using org.apache.hive.hcatalog.pig.HCatStorer(); ERROR that I AM GETTING IS: ARNING: Use "yarn jar" to launch YARN applications. 16/02/23 03:31:35 INFO pig.ExecTypeProvider: Trying ExecType : LOCAL 16/02/23 03:31:35 INFO pig.ExecTypeProvider: Trying ExecType : MAPREDUCE 16/02/23 03:31:35 INFO pig.ExecTypeProvider: Picked MAPREDUCE as the ExecType 2016-02-23 03:31:35,609 [main] INFO org.apache.pig.Main - Apache Pig version 0.15.0.2.3.4.0-3485 (rexported) compiled Dec 16 2015, 04:30:33 2016-02-23 03:31:35,609 [main] INFO org.apache.pig.Main - Logging error messages to: /hadoop/yarn/local/usercache/admin/appcache/application_1455824286177_0013/container_e03_1455824286177_0013_01_000002/pig_1456198295607.log 2016-02-23 03:31:38,312 [main] ERROR org.apache.pig.Main - ERROR 2997: Encountered IOException. File –useHCatalog does not exist Details at logfile: /hadoop/yarn/local/usercache/admin/appcache/application_1455824286177_0013/container_e03_1455824286177_0013_01_000002/pig_1456198295607.log 2016-02-23 03:31:38,339 [main] INFO org.apache.pig.Main - Pig script completed in 3 seconds and 412 milliseconds (3412 ms) ... View more

awesome @Neeraj Sabharwal Thanks ... View more