E-commerce Big Data Learning Note: User portrait

1, User portrait: User information labeling.

2. What can the user portrait do?

--the content is being sorted out

3. Show command usage

Show tables shows all the examples: Show table like ' ... _pre_food ';

Show partitions shows all partition examples: Show partitions fdm_prd_food partition (dt= ' 2015-01-01 ');

Show Table Extended Display extension Information example: Show table extended like Fdm_ord_order;

Show Table properties shows attributes for all tables

Show indexes shows all index examples: show indexes on Fdm_prd_food;

The Show create table shows an example of creating tables statement: Show creation table Fdm_prd_food;

Show databases shows all database examples: show databases like ' *dm* ';

Show columns Display all columns

Show functions shows all functions

Show granted roles and privileges display roles and permissions

Show Locks Display Lock

Show conf display configuration file

Show Transactions Display transactions

4. Usage of desc (describe) command

Desc database shows an example of a DB detail: show databases FDM;

Desc table/view/column showing Table/view/Column Details Example: DESC formatted fdm_ord_order; Displays information for the formatted table.

DESC partition Show details of the partition

5. Hive Command Classification

Interactive command: Hive Quit exit Example: Hive-e "set;" | grep tasks filters out the parameters that contain tasks in the set.

Parameter settings: Set reset

Resource file Management: Add list Delete

Execute shell command:!cmd

HDFs file operation: Dfs-ls Dfs-cat

Hiveql:<query string>

Executing external File command: source file

6. Hive command Line interface parameters

-D,--define<key = value> defines a variable to use in hive

-E <query string> executes the SQL in the following quotation marks

-F <filename> Execute SQL in a SQL file

-H,--help printing help information

-I <filename> execute initialization file

-p port number to connect to hive server

-H

--hiveconf<property=value> Setting properties

--hivevar<key=value> Setting variables

-s silent mode, the log is not printed.

-V,--verbose redundant mode, will print out execution statement and execution log

E-commerce Big Data Learning Note: User portrait