ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / Big Data / Managing Hive databases
  • Overview
  • How to handle a database with Hive in programming?
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Overview
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
	// La connexion s'est bien passée
	// Utilisation de la connexion pour exécuter des requêtes SQL
	IF SQLExec("SELECT * FROM EQUIPE WHERE NOM='HOU'") = True THEN
		// Traitement de la requête
	ELSE
		// Échec de la requête : affichage d'un message explicatif
		SQLInfo("RECHCLIENTPARNOM")
		Error("Erreur" + SQL.Error + "dans la requête : ", SQL.MesError)
	END
ELSE
	// La connexion a échoué : affichage d'un message explicatif
	SQLInfo()
	Error("La connexion à la source de données a échoué." + CR + ...
		"Code erreur : " + SQL.Error + CR + SQL.MesError)
END
// Dans tous les cas (connexion OK ou pas)
SQLDisconnect()

Please note: HiveQL database access is only available at runtime on Windows Vista or Windows Server 2008.
Minimum version required
  • Version 21
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help