Though this is an old post, want to know if there's a solution for the original query. I have concerns similar to narasimha meruva I've built an MR project in eclipse and tested in it Eclipse, where in I created a Driver class with all configurations(mapper class, number of reducer etc). Next, I packed it into a JAR and ran it as MR job(Hadoop JAR command) in my cluster to check if it works fine. Next, I simply want to execute this MR JAR in oozie and thus oozie should have provision to execute the JAR WITHOUT providing the configuration parameters again since they are already present in driver class. Please do post if anyone knows the best practice. ... View more

HI TomasTF, I tried 3 ways, 1. Data without newline : sample below  {"id":"P121", "name":"Round Tee", "reseller":"Puma", "category":"Top Wear", "price":2379.06, "discount":22.57, "profit_percent":20.13},{"id":"P122", "name":"pant", "reseller":"Reebok", "category":"bottom", "price":1234.99, "discount":99.99, "profit_percent":67.12} 2. Data with new line and comma {"id":"P121", "name":"Round Tee", "reseller":"Puma", "category":"Top Wear", "price":2379.06, "discount":22.57, "profit_percent":20.13}, {"id":"P122", "name":"pant", "reseller":"Reebok", "category":"bottom", "price":1234.99, "discount":99.99, "profit_percent":67.12} 3. Data with new line and without comma {"id":"P121", "name":"Round Tee", "reseller":"Puma", "category":"Top Wear", "price":2379.06, "discount":22.57, "profit_percent":20.13} {"id":"P122", "name":"pant", "reseller":"Reebok", "category":"bottom", "price":1234.99, "discount":99.99, "profit_percent":67.12} all three failed with same error Next, I deleted the table and recreated with Double CREATE EXTERNAL TABLE IF NOT EXISTS testtable (Id string,Name string,Reseller string,Category string,Price Double,Discount Double,Profit_percent Double) ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe' location "/user/testuser/test"; with Data in below format (new line without comma) {"id":"P121", "name":"Round Tee", "reseller":"Puma", "category":"Top Wear", "price":2379.06, "discount":22.57, "profit_percent":20.13} {"id":"P122", "name":"pant", "reseller":"Reebok", "category":"bottom", "price":1234.99, "discount":99.99, "profit_percent":67.12} Now Select Query is not fetching result without error. However, am still now sure why Decimal was throwing error. ... View more