hadoop大数据就业课程课件代码五基础篇.pptxVIP

深入浅出Hadoop, HbaseStorm（新版） ;Basics Data types Partitioned Tables ;usage: hive -d,--define key=value Variable subsitution to apply to hive commands. e.g. -d A=B or --define A=B --database databasename Specify the database to use -e quoted-query-string SQL from command line -f filename SQL from files -H,--help Print help information -h hostname connecting to Hive Server on remote host --hiveconf property=value Use value for given property --hivevar key=value Variable subsitution to apply to hive commands. e.g. --hivevar A=B -i filename Initialization SQL file -p port connecting to Hive Server on port number -S,--silent Silent mode in interactive shell -v,--verbose Verbose mode (echo executed SQL to the console); Create/Drop/Alter Database Use Database Create/Drop/Truncate Table (External table) Alter Table/Partition/Column Create/Drop/Alter View Create/Drop/Alter Index Create/Drop Function Create/Drop/Grant/Revoke Roles and Privileges Show Describe; Loading files into tables Inserting data into Hive Tables from queries Writing data into the filesystem from queries Inserting values into tables from SQL Update Delete;Primitive Data Types Collection Data Types Text File Encoding of Data Values ;Primitive Data Types;Collection Data Types;Text File Encoding of Data Values;CREATE TABLE IF NOT EXISTS mydb.employees ( name STRING, salary FLOAT, subordinates ARRAYSTRING, deductions MAPSTRING, FLOAT, address STRUCTstreet:STRING, city:STRING, state:STRING, zip:INT) LOCATION /user/hive/warehouse/mydb.db/employees;;CREATE TABLE employees ( name STRING, salary FLOAT, subordinates ARRAYSTRING, deductions M