ok I found two hiveserver log files , one as hiveserver2.log and one as hive-server2.log , I will upload both ... View more

don't I have to kill the hive session first and then run it in background as : nohup ($HIVE_HOME/bin/hive --hiveconf hive.root.logger=DEBUG,DRFA & how can I find out what is $HIVE_HOME ? ... View more

sorry iam just learning hadoop so please tell me where I can find this hiveserver2.log file ? also whats RM and how can I check if the job has launced, I use hortonworks and I don't see anywhere on the dashboard such info. ... View more

also HIVE command is hanging ... [hdfs@ip-172-31-8-77 ~]$ hive WARNING: Use "yarn jar" to launch YARN applications. Logging initialized using configuration in file:/etc/hive/2.4.2.0-258/0/hive-log4j.properties ... View more

btw I have started the resourcemanager on the masternode and the nodemanager on each slavenodes. ... View more

I can see the table definitions so it must be able to make database connection ,but insert hangs 0: jdbc:hive2://SecondaryMaster:10000> show tables; +------------+--+ | tab_name | +------------+--+ | customers | | person | +------------+--+ 2 rows selected (0.063 seconds) 0: jdbc:hive2://SecondaryMaster:10000> describe person; +------------+------------+----------+--+ | col_name | data_type | comment | +------------+------------+----------+--+ | id | int | | | firstname | string | | | lastname | string | | +------------+------------+----------+--+ 3 rows selected (0.091 seconds) 0: jdbc:hive2://SecondaryMaster:10000> INSERT INTO person (id, firstname, lastname) VALUES (1, 'John', 'Smith'); INFO : Tez session hasn't been created yet. Opening session ... View more

I need help , HIVE still not working , INSERT command just hangs [root@ip-172-31-11-180 ~]# su - hive [hive@ip-172-31-11-180 ~]$ id uid=501(hive) gid=502(hadoop) groups=502(hadoop) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 [hive@ip-172-31-11-180 ~]$ beeline WARNING: Use "yarn jar" to launch YARN applications. Beeline version 1.2.1.2.3.4.0-3485 by Apache Hive beeline> !connect jdbc:hive2://SecondaryMaster:10000 Connecting to jdbc:hive2://SecondaryMaster:10000 Enter username for jdbc:hive2://SecondaryMaster:10000: hadoop Enter password for jdbc:hive2://SecondaryMaster:10000: ****** Connected to: Apache Hive (version 1.2.1.2.3.4.0-3485) Driver: Hive JDBC (version 1.2.1.2.3.4.0-3485) Transaction isolation: TRANSACTION_REPEATABLE_READ 0: jdbc:hive2://SecondaryMaster:10000> INSERT INTO person (id, firstname, lastname) VALUES (1, 'John', 'Smith'); INFO : Tez session hasn't been created yet. Opening session ... View more

hadoop user i used in the connect command was a user i created in Ambari , does it already get created on Linux? i was running hdfs commands under hdfs and hive commands under hive Linux account. please advise me on how to properly run each application .should i use a common account or indivisual accounts for each application? ... View more

it has created the HIVE file in the newly created directory so its doing something [hdfs@ip-172-31-11-180 ~]$ hdfs dfs -ls /user drwxr-xr-x - hadoop hdfs 0 2016-05-04 17:14 /user/hadoop [hdfs@ip-172-31-11-180 ~]$ hdfs dfs -ls /user/hadoop Found 1 items drwxr-xr-x - hadoop hdfs 0 2016-05-04 17:14 /user/hadoop/.hiveJars ... View more