Home > Workload Solutions > Oracle > Guides > Design Guide — Oracle Big Data SQL on Dell EMC PowerFlex > Configuring Big Data SQL on Hadoop clusters
We followed these steps to configure Big Data SQL on Hadoop clusters:
[root@hadoop-namenode oracle] #. / BDSJaguar-4.1.0.run
{
"cluster": {
"name”: "cluster1",
"database compatibility”: [ "19”]
},
"api”: {
"port”: 7180,
"skip_health_check”: "true",
"restart_stale” : "false"
},
"object_store_support”: {
"enabled”: "false",
"cell_http_proxy" : "http://proxy1.server.com:80",
"cell_no_proxy”: "localhost,127.0.0. 1, my.domain.com, my.domain.com",
"database_http_proxy" : "http://proxy2.server.com:80",
"database_no_proxy”: "localhost,127.0.0.1, my.domain.com,my.domain.com"
},
"repositories”: {
"dir”: [ "/home/oracle/parcels"]
},
"network”: {
"use_infiniband” : "false",
"selection_subnet”: "172.168.87.0/24"
},
"security”: {
"database_auth_enabled”: "false",
"impersonation_enabled”: "true",
"impersonation_usehosts”: "true",
"impersonation_blacklist”: "hdfs, hive"
},
"memory”: {
"min_hard_limit”: 16384,
"max_percentage" : 30
}
}
[root@hadoop-namenode BDSJaguar] #. /jaguar install myconfig.json
BigDataSQL: =============================================================
BigDataSQL: Oracle Big Data SQL 4.1.0.
BigDataSQL: Starting execution on Tue Nov 3 23:51:09 2020.
BigDataSQL: in directory: /opt/oracle/BDSJaguar.
BigDataSQL: and hostname: hadoop-namenode. localdomain.
BigDataSQL: IP address: 172.168.87.180.
BigDataSQL: DB version support: 19,18,12.2.
BigDataSQL: Object Store support: Disabled.
BigDataSQL: API url: http://hadoop-namenode.localdomain:7180.
BigDataSQL: Waiting for management server to respond...
BigDataSQL: Configuration json file name: myconfig. json.
BigDataSQL: WARNING: Cluster health will not be checked!!!.
Cloudera Manager user: admin
Password:
BigDataSQL: Authentication succeeded.
BigDataSQL: API version: 32.
BigDataSQL: Cluster name: Cluster 1.
BigDataSQL: Cluster type: CDH.
BigDataSQL: Cluster version: CDH6.
BigDataSQL: full version: 6.2.1.
BigDataSQL: WARNING: CDH6 clients will be installed on database side through yum, Internet access is required there.
BigDataSQL: Service: BIGDATASQL.
BigDataSQL: Verifying service configuration.
BigDataSQL: Connection type: Ethernet.
BigDataSQL: Initialization completed.
BigDataSQL: Copying CSD to Cloudera Manager.
BigDataSQL: Restarting management server...
Redirecting to /bin/systemctl restart cloudera-scm-server. service
BigDataSQL: Waiting for management server to respond...
BigDataSQL: Restarting Cloudera Management service.
BigDataSQL: Starting deployment server.
BigDataSQL: Analyzing cluster ....
BigDataSQL: Checking for Big Data SQL requirements.
BigDataSQL: Preparing installation.
BigDataSQL: Installing Big Data SQL agents.
BigDataSQL: No http_proxy variable defined.
BigDataSQL: Installing Big Data SQL servers.
BigDataSQL: Starting bigdatasql service.
BigDataSQL: Skip restart stale services by user request.
BigDataSQL: WARNING: You will need to restart manually stale services if any.
BigDataSQL: Restarting Cloudera Management service.
BigDataSQL: Big Data SQL task completed.
BigDataSQL: Creating database side bundle.
BigDataSQL: WARNING: OL5 native libraries missing for version 3.0.0, compression will not be supported on database side.
BigDataSQL: Creating bundle file.
BigDataSQL: Bundle file created: /opt/oracle/BDSJaguar/db-bundles/bds-4.1.0-db-cluster1-201103.2351.zip.
BigDataSQL: INSTALL workflow completed.