However, the hue SQL development platform of the company is getting slower and slower recently. During development, the hue SQL system checks whether some small SQL statements meet the requirements. Some large SQL statements may be divided into several or dozens of sub-SQL statements for verification. If you have to wait a few minutes for each small SQL to see the results, it will inevitably lead to inefficient SQL development

Therefore, it is necessary to build a big data SQL development platform locally

Cloudera company provides a key to start the virtual machine, convenient reference: www.cloudera.com/downloads/q…

Cloudera also supports virtual Box, KVM, Docker Image and other VIRTUAL machine systems. You can choose by yourself

Obtain the Hue VM

Configuring a Static IP Address

After a VM is started, Hue, Hive, and Impala are available by default. The hue, Hive, and Impala are normally accessed from a browser outside the VM. To ensure vm hue service stability, assign a fixed IP address to the VM

Add a new network card in the Preferences for vmware Fusion

Then add the nic to the HUE VM

After logging in to the system, run ifconfig to obtain the hardware address of the second NIC

Run the vi /etc/sysconfig/network-scripts/ifcfg-eth1 command to apply for a fixed IP address on the new NIC

DEVICE="eth1"
BOOTPROTO="static"
IPV6INIT="no"
MTU="1500"
ONBOOT="yes"
TYPE="Ethernet"
IPADDR="192.168.26.24"
NETMASK="255.255.255.0"
GATEWAY="192.168.26.2"
DNS1="192.168.26.2"
HWADDR="00:0C:29:02:BC:6B"
Copy the code

Restart the VIRTUAL machine, the static IP is ok, the effect is as follows

Test data import, SQL execution

Access to the static IP configuration above 8888 port can use hue: http://192.168.26.24:8888/, the results are as follows

Experience the speed of local Hue

A couple of points to note

The default Hue user name and password is cloudera cloudera

When a file is uploaded from Hue, the file must be uploaded to the directory of the corresponding query engine to import the file to the data store

The resources

  1. www.cloudera.com/downloads/q…
  2. www.voidcn.com/article/p-y…