https://hortonworks.com/hadoop-tutorial/hello-world-an-introduction-to-hadoop-hcatalog-hive-and-pig/#section_1 ... View more

Hello, I was doing the following tutorial https://hortonworks.com/hadoop-tutorial/hello-world-an-introduction-to-hadoop-hcatalog-hive-and-pig/#step5.b.1 I configured the ODBC for windows 7 but i am not sure which username to use while configuring it. After this when i click i am here: Open a new blank workbook. Select Data tab at the top then select “Get External Data” and then select “From Other Data Sources”. Then at the bottom select “From Microsoft Query”. Choose your data source and ours is called Hadoop and you will then see the Query Wizard. We will import the avg_mileage table. I do not see the database for hadoop. This is the step i am stuck. I see following in my excel. Can anyone help me from this point. TIA ... View more

Hi, I am new to Hadoop. I started uisng Ambari. I am following this tutorial : - https://hortonworks.com/hadoop-tutorial/hello-world-an-introduction-to-hadoop-hcatalog-hive-and-pig/#section_4 in this section : - 2.6.2 LOAD SAMPLE DATA OF TRUCK_MILEAGE I am at the last step number 8 where it says Execute the “average mpg” query and view its results. This query is running from last 2 hours. I believe its not normal. Can anyone help me. I can't really move forward. ... View more

Iam using Ambari. I ran few queries and got the following errors: Vertex failed, vertexName=Map 1, vertexId=vertex_1469016431837_0001_1_00, diagnostics= Task failed, taskId=task_1469016431837_0001_1_00_000000, diagnostics= TaskAttempt 0 failed, info= Error: Failure while running task:java.lang.RuntimeException: java.lang.OutOfMemoryError: Java heap space at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:159) at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.run(TezProcessor.java:139) ... View more