Hadoop SDK and Tutorials for Microsoft .NET Developers
How to Communicate to Hadoop via Hive using .NET/C#
How to Create MapReduce Jobs for Hadoop Using C#
ASP.NET is a web application framework developed and marketed by Microsoft to allow programmers to build dynamic web sites, web applications and web services. It was first released in January 2002 with version 1.0 of the .NET Framework, and is the successor to Microsoft's Active Server Pages (ASP) technology. ASP.NET is built on the Common Language Runtime (CLR), allowing programmers to write ASP.NET code using any supported .NET language.
CREATE EXTERNAL TABLE
test (EmployeeID Int,FirstName String,Designation
String,Salary Int,Department String)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ","
LOCATION '/user/hdfs/Hive';
We will try to update the salary of employee id 19 from 45,000 to 50,000. hive> UPDATE test
SET salary = 50000
WHERE employeeid = 19;
FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction m anager that does not support these operations.
hive.support.concurrency – true
hive.enforce.bucketing – true
hive.exec.dynamic.partition.mode – nonstrict
hive.txn.manager –org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
hive.compactor.initiator.on – true
hive.compactor.worker.threads – 1
You can set these configuration in hive-site.xml (after setting restart Hive ) for ever or via terminal. create table HiveTest
(EmployeeID Int,FirstName String,Designation String,
Salary Int,Department String)
clustered by (department) into 3 buckets
stored as orc TBLPROPERTIES ('transactional'='true') ;
3. Load data into HiveTest from a staging table,which contains the original data. from stagingtbl
insert into table HiveTest
select employeeid,firstname,designation,salary,department;
update HiveTest
set salary = 50000
where employeeid = 19;
insert into table HiveTest
values(21,'Hive','Hive',0,'B');
delete from HiveTest
where employeeid=19;
INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);
once the bracket close it will take the values and look for another value in next bracket.