How to Query Hive Tables : SELECT Statement

Official Website: bigdataelearning.com/ How to Query Hive Tables : SELECT Statement Here is the select statement syntax to select rows from hive tables using certain conditions. SELECT col1, col2, col3 FROM TABLENAME WHERE [condition] GROUP BY col1 ORDER BY LIMIT 10;  SELECT is the clause and here you can specify the list of columns that we are retrieving from the table or we can use an asterisk to fetch all the columns available in the hive table.  “FROM tableName” indicates the hive table from which we are going to fetch records.  WHERE is the condition part. We can specify the condition on which SELECT should retrieve the records.  GROUP BY is used if we need to group the records based on certain column value.  ORDER BY clause is used to sort the rows based on certain conditions  LIMIT is used to limit the number of records being fetched during every retrieval.

• #education
• #how_to_query_hive_tables
• #querying_hive_tables
• #select_statement_in_hive
• #select_clause_in_hive
• #group_by_in_hive
• #hive_limit_statement
• #hive_order_by_statement
• #hive_select_statement_demo
• #how_to_retrieve_data_from_hive_tables