https://onnocenter.or.id/wiki/index.php?action=history&feed=atom&title=Hadoop%3A_Hive_contekan_SQL 2026-05-04T22:46:05Z Revision history for this page on the wiki MediaWiki 1.35.4 https://onnocenter.or.id/wiki/index.php?title=Hadoop:_Hive_contekan_SQL&diff=44965&oldid=prev 2015-11-13T22:25:25Z

<p>New page: Sumber: http://hortonworks.com/hadoop/hive/#section_5 SQL and HiveQL Apache Hive is data warehouse infrastructure built on top of Apache Hadoop for providing data summarization, ad-hoc...</p> <p><b>New page</b></p><div>Sumber: http://hortonworks.com/hadoop/hive/#section_5<br /> <br /> <br /> <br /> SQL and HiveQL<br /> <br /> Apache Hive is data warehouse infrastructure built on top of Apache Hadoop for providing data summarization, ad-hoc query, and analysis of large datasets. It provides a mechanism to project structure onto the data in Hadoop and to query that data using a SQL-like language called HiveQL (HQL).<br /> <br /> Naturally, there are a bunch of differences between SQL and HiveQL, but on the other hand there are a lot of similarities too, and recent releases of Hive bring that SQL-92 compatibility closer still.<br /> <br /> Below is some basic information to get you started. Of course, if you really want to get to grips with Hive, then take a look at the full language manual.<br /> SQL to HQL Cheat Sheet<br /> <br /> <br /> Retrieving Information<br /> Function MySQL Hive<br /> Retrieving Information (General) SELECT from_columns FROM table WHERE conditions; SELECT from_columns FROM table WHERE conditions;<br /> Retrieving All Values SELECT * FROM table; SELECT * FROM table;<br /> Retrieving Some Values SELECT * FROM table WHERE rec_name = &quot;value&quot;; SELECT * FROM table WHERE rec_name = &quot;value&quot;;<br /> Retrieving With Multiple Criteria SELECT * FROM TABLE WHERE rec1 = &quot;value1&quot; AND rec2 = &quot;value2&quot;; SELECT * FROM TABLE WHERE rec1 = &quot;value1&quot; AND rec2 = &quot;value2&quot;;<br /> Retrieving Specific Columns SELECT column_name FROM table; SELECT column_name FROM table;<br /> Retrieving Unique Output SELECT DISTINCT column_name FROM table; SELECT DISTINCT column_name FROM table;<br /> Sorting SELECT col1, col2 FROM table ORDER BY col2; SELECT col1, col2 FROM table ORDER BY col2;<br /> Sorting Reverse SELECT col1, col2 FROM table ORDER BY col2 DESC; SELECT col1, col2 FROM table ORDER BY col2 DESC;<br /> Counting Rows SELECT COUNT(*) FROM table; SELECT COUNT(*) FROM table;<br /> Grouping With Counting SELECT owner, COUNT(*) FROM table GROUP BY owner; SELECT owner, COUNT(*) FROM table GROUP BY owner;<br /> Maximum Value SELECT MAX(col_name) AS label FROM table; SELECT MAX(col_name) AS label FROM table;<br /> Selecting from multiple tables (Join same table using alias w/”AS”) SELECT pet.name, comment FROM pet, event WHERE pet.name = event.name; SELECT pet.name, comment FROM pet JOIN event ON (pet.name = event.name)<br /> Metadata<br /> Function MySQL Hive<br /> Selecting a database USE database; USE database;<br /> Listing databases SHOW DATABASES; SHOW DATABASES;<br /> Listing tables in a database SHOW TABLES; SHOW TABLES;<br /> Describing the format of a table DESCRIBE table; DESCRIBE (FORMATTED|EXTENDED) table;<br /> Creating a database CREATE DATABASE db_name; CREATE DATABASE db_name;<br /> Dropping a database DROP DATABASE db_name; DROP DATABASE db_name (CASCADE);<br /> <br /> <br /> <br /> <br /> <br /> <br /> ==Referensi==<br /> <br /> * http://hortonworks.com/hadoop/hive/#section_5</div>

Onnowpurbo