Николай Бараненко

For optimal performance of LONG data types, HP Vertica recommends that you:

Use the LONG data types as storage only containers; HP Vertica does not support operations on their content.
Use the VARBINARY and VARCHAR data types, instead of their LONG counterparts, whenever possible. The VARBINARY and VARCHAR data types are more flexible and have a wider range of operations.

SELECT * FROM WAREHOUSE.ALL_EVENTS a 
WHERE REGEXP_LIKE(a.original_data, 'd963');

from pywebhdfs.webhdfs import PyWebHdfsClient
from pprint import pprint


hdfs = PyWebHdfsClient(host='hadoop01',port='50070', user_name='hadoop')  # your Namenode IP & username here
my_dir = '/examples/Reutov_mos_obl.csv'
pprint(hdfs.list_dir(my_dir))

# The java implementation to use.
export JAVA_HOME=${JAVA_HOME}
# export JAVA_HOME=/opt/jdk1.8.0_144
export HADOOP_OPTS=-Djava.net.preferIPv4Stack=true
export HADOOP_CONF_DIR=/app/hadoop/etc/hadoop/

hadoop-daemon.sh --config /app/hadoop/etc/hadoop --script hdfs start namenode
hadoop-daemon.sh --config /app/hadoop/etc/hadoop --script hdfs start datanode
/app/hadoop/sbin/start-dfs.sh
yarn-daemon.sh --config /app/hadoop/etc/hadoop  start resourcemanager
yarn-daemon.sh --config /app/hadoop/etc/hadoop  start nodemanager
yarn-daemon.sh --config /app/hadoop/etc/hadoop  start proxyserver
/app/hadoop/sbin/start-yarn.sh
mr-jobhistory-daemon.sh --config /app/hadoop/etc/hadoop start historyserver

[hadoop@hadoop01 ~]$ jps
29520 JobHistoryServer
29249 NodeManager
28467 NameNode
29000 ResourceManager
28555 DataNode
29933 Jps
28862 SecondaryNameNode

ipmitool sensor -H 192.168.0.51 -I lanplus -U username -P password -L ADMINISTRATOR

•	Имя - PS0/P_IN
•	Тип - IPMI агент
•	Ключ - PS0_P_IN
•	IPMI датчик - PS0/P_IN