About
Hive in Powercenter.
Hive is a relation database and your create therefore relational data object. If you don't see the connection, you don't have access to it.
Articles Related
Example with Azure
- In the admin console, add a connection with the following JDBC url:
jdbc:hive2://CLUSTERNAME.azurehdinsight.net:443/default;transportMode=http;ssl=true;httpPath=/hive2
- In the dev tool, New Physical Data Object > Relational > Hive (Restart it if you have change any configuration
)
Support
Configure the mapping to run in the Hadoop environment
[Error] [Native Validation] The Write transformation [Write_Device] cannot write to a Hive target when the mapping runs in the native environment. Configure the mapping to run in the Hadoop environment.
In the mapping properties, you can change the runtime environement:
