Home > other >  Hive + hbase integration
Hive + hbase integration

Time:09-22


completing hadoop pseudo-distributed environmentHadoop2.7.3 + hbase1.2.6 + hive1.2.2

The question now is don't know how to set up, making the hive can be integrated hbase, online search, tried, an error is as follows:
[root @ hadoop bin] #./hive

Logging the initialized using the configuration file: in/usr/Java/hadoop/hive/conf/hive - log4j. Properties
Hive> The CREATE TABLE hbase_hive_1 (key int, the value string)
STORED BY '. Org. Apache hadoop. Hive. Hbase. HBaseStorageHandler '
WITH SERDEPROPERTIES (" hbase. Columns. The mapping "=" : the key of cf1: val ")
TBLPROPERTIES (" hbase table. The name "=" xyz ");
FAILED: Execution Error, the return code from 1 org.. Apache hadoop. Hive. Ql. Exec. DDLTask. MetaException (. Message: org. Apache hadoop, hbase client. RetriesExhaustedException: FAILED after attempts=36, exceptions:
Sat Jun 17 14:39:56 CST 2017, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=69311: row 'xyz, and on the table' hbase: meta at region=hbase: meta, and 1.1588230740, the hostname=hadoop, 30, 16201149663973 seqNum=0

At org, apache hadoop. Hbase. Client. RpcRetryingCallerWithReadReplicas. ThrowEnrichedException (RpcRetryingCallerWithReadReplicas. Java: 276)
At org, apache hadoop. Hbase. Client. ScannerCallableWithReplicas. Call (210) ScannerCallableWithReplicas. Java:
At org, apache hadoop. Hbase. Client. ScannerCallableWithReplicas. Call (60) ScannerCallableWithReplicas. Java:
At org, apache hadoop. Hbase. Client. RpcRetryingCaller. CallWithoutRetries (RpcRetryingCaller. Java: 210)
At org, apache hadoop. Hbase. Client. ClientScanner. Call (327) ClientScanner. Java:
At org, apache hadoop. Hbase. Client. ClientScanner. NextScanner (ClientScanner. Java: 302)
At org, apache hadoop. Hbase. Client. ClientScanner. InitializeScannerInConstruction (ClientScanner. Java: 167)
At org, apache hadoop. Hbase. Client. ClientScanner. & lt; init> (ClientScanner. Java: 162)
At org, apache hadoop. Hbase. Client. HTable. GetScanner (HTable. Java: 797)
At org, apache hadoop. Hbase. MetaTableAccessor. FullScan (MetaTableAccessor. Java: 602)
At org, apache hadoop. Hbase. MetaTableAccessor. TableExists (MetaTableAccessor. Java: 366)
At org, apache hadoop. Hbase. Client. HBaseAdmin. TableExists (HBaseAdmin. Java: 406)
At org, apache hadoop. Hbase. Client. HBaseAdmin. TableExists (HBaseAdmin. Java: 416)
At org, apache hadoop. Hive. Hbase. HBaseStorageHandler. PreCreateTable (HBaseStorageHandler. Java: 200)
At org, apache hadoop. Hive. Metastore. HiveMetaStoreClient. CreateTable (HiveMetaStoreClient. Java: 665)
At org, apache hadoop. Hive. Metastore. HiveMetaStoreClient. CreateTable (HiveMetaStoreClient. Java: 658)
At sun. Reflect. NativeMethodAccessorImpl. Invoke0 (Native Method)
At sun. Reflect. NativeMethodAccessorImpl. Invoke (NativeMethodAccessorImpl. Java: 62)
At sun. Reflect. DelegatingMethodAccessorImpl. Invoke (43) DelegatingMethodAccessorImpl. Java:
The at Java. Lang. Reflect. Method. Invoke (483) Method. The Java:
At org, apache hadoop. Hive. Metastore. RetryingMetaStoreClient. Invoke (RetryingMetaStoreClient. Java: 156)
At com. Sun. Proxy. $Proxy9. CreateTable (Unknown Source)
At org, apache hadoop. Hive. Ql. Metadata. Hive. CreateTable (hive. Java: 714)
At org, apache hadoop. Hive. Ql. Exec. DDLTask. CreateTable (DDLTask. Java: 4135)
At org, apache hadoop. Hive. Ql. Exec. DDLTask. Execute (DDLTask. Java: 306)
At org, apache hadoop. Hive. Ql. Exec. Task. ExecuteTask (160) Task. Java:
At org, apache hadoop. Hive. Ql. Exec. TaskRunner. RunSequential (TaskRunner. Java: 88)
At org, apache hadoop. Hive. Ql. Driver. LaunchTask (1676) Driver. Java:
At org, apache hadoop. Hive. Ql. Driver. The execute (1435) Driver. Java:
At org, apache hadoop. Hive. Ql. Driver. RunInternal (1218) Driver. Java:
At org, apache hadoop. Hive. Ql. Driver. The run (1082) Driver. Java:
At org, apache hadoop. Hive. Ql. Driver. The run (1072) Driver. Java:
At org, apache hadoop. Hive. Cli. CliDriver. ProcessLocalCmd (CliDriver. Java: 213)
At org, apache hadoop. Hive. Cli. CliDriver. ProcessCmd (CliDriver. Java: 165)
At org, apache hadoop. Hive. Cli. CliDriver. ProcessLine (CliDriver. Java: 376)
At org, apache hadoop. Hive. Cli. CliDriver. ExecuteDriver (CliDriver. Java: 736)
At org, apache hadoop. Hive. Cli. CliDriver. Run (681) CliDriver. Java:
At org, apache hadoop. Hive. Cli. CliDriver. Main (621) CliDriver. Java:
At sun. Reflect. NativeMethodAccessorImpl. Invoke0 (Native Method)
At sun. Reflect. NativeMethodAccessorImpl. Invoke (NativeMethodAccessorImpl. Java: 62)
At sun. Reflect. DelegatingMethodAccessorImpl. Invoke (43) DelegatingMethodAccessorImpl. Java:
The at Java. Lang. Reflect. Method. Invoke (483) Method. The Java:
At org, apache hadoop. Util. RunJar. Run (221) RunJar. Java:
At org, apache hadoop. Util. RunJar. Main (136) RunJar. Java:
Under Caused by: java.net.SocketTimeoutException: callTimeout=60000, callDuration=69311: row 'xyz, and on the table' hbase: meta at region=hbase: meta, and 1.1588230740, the hostname=hadoop, 30, 16201149663973 seqNum=0
At org, apache hadoop. Hbase. Client. RpcRetryingCaller. CallWithRetries (RpcRetryingCaller. Java: 169)
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
  • Related