6/16/2023 0 Comments Commands hive drawitTo insert the data from the cricket table to external table cricket text:Ĭommand: from cricket cric insert overwrite tableĬric.Runs_Scored, cric.Balls_Faced,cric.Strike_Rate (Player_NameSTRING,Runs_ScoredINT,Balls_FaceĭINT, Strike_Rate FLOAT) row format delimitedįields terminated by ‘,’ stored as textfile LOCATION Runs_ScoredINT,Balls_FacedINT,Strike_RateįLOAT) row format delimited fields terminated by ‘,’Ĭommand: LOAD DATA INPATH ‘/user/cloudera/cricketdoc.txt’ OVERWRITE INTO table cricket Ĭommand: create external table cricket text To use a particular database to create a table:Ĭommand: Hadoop fs -copyFromLocal ‘–LOCATION OR PATH OF DOCUMENT–’ /user/Cloudera (On new terminal) Origin, Dest FROM FlightInfo2007WHERE (Month =ħ AND DayofMonth = 3) AND (Origin=’JFK’ AND SELECT Year, Month, DepTime, ArrTime, FlightNum, SELECT Year, Month, DayofMonth, DayOfWeek, DepTime,ArrTime, UniqueCarrier, FlightNum,ĪirTime, ArrDelay, DepDelay, Origin, Dest, Cancelled,Ĭommand: CREATE TABLE myflightinfo2008 AS To load partition data in my flight info from flightinfo2008: STRING)COMMENT ‘FlightInfoTable’PARTITIONEDįIELDS TERMINATED BY ‘,’LINES TERMINATED BY TINYINT, DayOfWeek TINYINT,DepTime SMALLINT,įlightNum STRING,AirTime SMALLINT, ArrDelayĭest STRING, Cancelled SMALLINT,CancellationCode SMALLINT, DontQueryMonth TINYINT, DayofMonth TBLPROPERTIES (‘creator’=’Bruce Brown’, ‘created_at’=’Thu Sep 19 10:58:’) Ĭommand: LOAD DATA LOCAL INPATH ‘/home/cloudera/Desktop/2008.csv’ INTO TABLE flightinfo2008 SMALLINT,LateAircraftDelaySMALLINT)COMMENT SMALLINT,NASDelay SMALLINT, SecurityDelay SMALLINT,CarrierDelay SMALLINT, WeatherDelay SMALLINT,CancellationCode STRING, Diverted SMALLINT, DepDelay SMALLINT,Origin STRING, Select Command: To display a record from the selected table.ĭescribe table: Using the below command we can describe the property of a table.Īlter: Alter command is used to add or to make changes in current table property.Īdding Column: Using below given command we can new column in our existing table.Ĭommand: create table flightinfo2008(Year SMALLINT, Month TINYINT, DayofMonth TINYINT,ĬRSArrTime SMALLINT,UniqueCarrier STRING,ĪctualElapsedTime SMALLINT, CRSElapsedTime Using the below command we load data into the table from local or cloud storage. Use Database: Using below given command we can use a particular database.ĭrop Database: Using the below-given command we can remove a particular database.Ĭreate Table: Using the below command create a table with multiple columns and describing datatype of each column. Show Database: Using the below-given command we can list all databases. Using below given command we create a database. If you are the one who is a hunger to become the certified Pro Hadoop Developer? Or the one who is looking for the best Hadoop Training institute which offering advanced tutorials and Hadoop certification course to all the tech enthusiasts who are eager to learn the technology from starting Level to Advanced Level. Follow the below mentioned Hadoop Hive commands for Beginners which were originally designed by the world-class Trainers of Hadoop Training institute Professionals. Hadoop Hive Basic Commands, are you looking for a list of Top Rated Hive commands in Hadoop technology? Or the one who is casually glancing for the best platform which is listing the Hadoop Hive Commands with examples for beginners? Then you’ve landed on the Right Platform which is packed with Tons of Tutorials of Hive commands in Hadoop. Hadoop-Singlenode Using Hadoop 1.x Hadoop Singlenode Using Hadoop 2.x Hadoop cluster on AWS setup Hadoop Basic Linux Commands Hadoop Cluster on Google Cloud Platform (GCP) Hadoop Basic HDFS Commands Hadoop-Multinode Cluster setup What is Hadoop 3.0 Multinode Hadoop Cluster Setup on AWS Hadoop Hbase Configuration Hadoop Hbase Test Case Hadoop Basic PIG Commands with Examples Import and export data with Sqoop in HDFS Hadoop flume tutorial Hadoop-Oozie Hadoop-PIG with MapR Hadoop Hive Basic Commands Hadoop-Hbase using Eclipse Hadoop GCP with Hive Hadoop HBase Hadoop Hive Test case Hadoop Sqoop Functions Hadoop High Availability setup MapR Installation Guide Hadoop-Cluster Upgrade Commissioning and Decommissioning in Hadoop Hadoop Fair scheduler Hadoop-Spark With MapR Hadoop-Map_Side Join in Hive Introduction to Hadoop MapReduce Hadoop GCP with HBase Hadoop PIG Introduction Hadoop-Hive script with Oozie Hadoop HBase Serialization and DeSerialization Bucketing in Hive with Examples Hadoop Hive Partitioning
0 Comments
Leave a Reply. |