Is there any library that I can use to integrate Hive/Impala/Spark scripts using Robot Framework? I tried using pyodbc but it forces to connect to SQL Server:
*** Settings ***
Library DatabaseLibrary
Library OperatingSystem
Suite Setup Connect To Database pyodbc ${DBName} ${DBUser} ${DBPass} ${DBHost} ${DBPort}
Suite Teardown Disconnect From Database
*** Variables ***
${DBName} xxxx
${DBUser} xxxx
${DBPass} xxxx
${DBHost} xxxx
${DBPort} 10000
*** Test Cases ***
Create person table
${output}= Execute SQL String SELECT COUNT(*) FROM my_table
log to console ${output}
should be equal as strings ${output} None
The output:
Parent suite setup failed:
OperationalError: ('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (17) (SQLDriverConnect); [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (53
)')
Anyone have an example how I can connect Robot Framework to Hive/Impala?
Thanks!