|
|
|
|
|
- Overview
- How to handle a database with Hive in programming?
Managing Hive databases
 Available only with these kinds of connection
Hive is a software layer of Hadoop used to run queries. Hive uses the HiveQL language that is close to SQL. The developer specifies his query by using HiveQL (syntax derived from SQL) and the Hive engine translates this query to interrogate the HBase database in native mode.. In version 21, you have the ability to run HiveQL queries by using the SQL functions of WLanguage. How to handle a database with Hive in programming? To handle a database with Hive, you must use the SQL functions of WLanguage. You can: NumConnexion is int
NumConnexion = SQLConnect("master2.hadoop1.monserveur.com", "sa", "", "default", "HIVE")
IF NumConnexion <> 0 THEN
IF SQLExec("SELECT * FROM EQUIPE WHERE NOM='HOU'") = True THEN
ELSE
SQLInfo("RECHCLIENTPARNOM")
Error("Erreur" + SQL.Error + "dans la requête : ", SQL.MesError)
END
ELSE
SQLInfo()
Error("La connexion à la source de données a échoué." + CR + ...
"Code erreur : " + SQL.Error + CR + SQL.MesError)
END
SQLDisconnect()
Please note: HiveQL database access is only available at runtime on Windows Vista or Windows Server 2008.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|