HADOOP – Créer une table Hive en SAS Explicit SQL Pass-Through
1 2 3 4 5 |
proc sql; connect to hadoop(server='MON_SERVEUR' user='nicolas' password='monpasswordhive'); execute(create table persons(nom string)) by hadoop; execute(insert into persons values ('nicolas housset')) by hadoop; quit; |
![sql-hadoop-create-table-proc-content](https://www.nicolas-housset.fr/wp-content/uploads/2017/12/sql-hadoop-create-table-proc-content.jpg)
1 |
describe formatted persons; |
![sas-hadoop-describe-formated](https://www.nicolas-housset.fr/wp-content/uploads/2018/12/sas-hadoop-describe-formated.jpg)