Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 0: jdbc:hive2://localhost:10000> select * from emp;
- +------------+------------+-------------+-------------+------------+
- | emp.empno | emp.ename | emp.job | emp.deptno | emp.etype |
- +------------+------------+-------------+-------------+------------+
- | 7369 | SMITH | CLERK | 10 | PART_TIME |
- | 7400 | JONES | ENGINEER | 10 | FULL_TIME |
- | 7500 | BROWN | NIGHTGUARD | 20 | FULL_TIME |
- | 7510 | LEE | ENGINEER | 20 | FULL_TIME |
- +------------+------------+-------------+-------------+------------+
- 4 rows selected (0.643 seconds)
- 0: jdbc:hive2://localhost:10000> select * from emp order by empno;
- WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
- +------------+------------+-------------+-------------+------------+
- | emp.empno | emp.ename | emp.job | emp.deptno | emp.etype |
- +------------+------------+-------------+-------------+------------+
- | 7369 | SMITH | CLERK | 10 | PART_TIME |
- | 7400 | JONES | ENGINEER | 10 | FULL_TIME |
- | 7500 | BROWN | NIGHTGUARD | 20 | FULL_TIME |
- | 7510 | LEE | ENGINEER | 20 | FULL_TIME |
- +------------+------------+-------------+-------------+------------+
- 4 rows selected (225.852 seconds)
- <?xml version="1.0" encoding="UTF-8" standalone="no"?>
- <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
- <configuration>
- <property>
- <name>hive.mapred.mode</name>
- <value>nostrict</value>
- </property>
- <property>
- <name>javax.jdo.option.ConnectionURL</name>
- <value>jdbc:derby:;databaseName=metastore_db;create=true</value>
- </property>
- <property>
- <name>javax.jdo.option.ConnectionDriverName</name>
- <value>org.apache.derby.jdbc.EmbeddedDriver</value>
- </property>
- <property>
- <name>hive.exec.local.scratchdir</name>
- <value>/home/hadoop/tmp</value>
- </property>
- <property>
- <name>hive.downloaded.resources.dir</name>
- <value>/home/hadoop/tmp/${hive.session.id}_resources</value>
- </property>
- <property>
- <name>hive.querylog.location</name>
- <value>/home/hadoop/tmp</value>
- </property>
- <property>
- <name>hive.server2.logging.operation.log.location</name>
- <value>/home/hadoop/tmp/operation_logs</value>
- </property>
- </configuration>
- <?xml version="1.0" encoding="UTF-8"?>
- <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
- <configuration>
- <property>
- <name>dfs.replication</name>
- <value>1</value>
- </property>
- <property>
- <name>dfs.name.dir</name>
- <value>file:///home/hadoop/hadoopinfra/hdfs/namenode</value>
- </property>
- <property>
- <name>dfs.data.dir</name>
- <value>file:///home/hadoop/hadoopinfra/hdfs/datanode</value>
- </property>
- </configuration>
- <?xml version="1.0" encoding="UTF-8"?>
- <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
- <configuration>
- <property>
- <name>fs.default.name</name>
- <value>hdfs://localhost:9000</value>
- </property>
- <property>
- <name>hadoop.proxyuser.hive.groups</name>
- <value>*</value>
- </property>
- <property>
- <name>hadoop.proxyuser.hive.hosts</name>
- <value>*</value>
- </property>
- <property>
- <name>hadoop.proxyuser.hadoop.hosts</name>
- <value>*</value>
- </property>
- <property>
- <name>hadoop.proxyuser.hadoop.groups</name>
- <value>*</value>
- </property>
- </configuration>
- <?xml version="1.0"?>
- <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
- <configuration>
- <property>
- <name>mapreduce.framework.name</name>
- <value>yarn</value>
- </property>
- </configuration>
- <?xml version="1.0"?>
- <configuration>
- <property>
- <name>yarn.nodemanager.aux-services</name>
- <value>mapreduce_shuffle</value>
- </property>
- </configuration>
Add Comment
Please, Sign In to add comment