[
https://issues.apache.org/jira/browse/SPARK-36282?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yu Wang updated SPARK-36282:
----------------------------
Description:
hive version is 2.3.3, hbase version is 2.4.2;
CREATE EXTERNAL TABLE `temp.mapping_from_hbase`(
`tuid` string COMMENT '',
`index` int COMMENT '')
ROW FORMAT SERDE
'org.apache.hadoop.hive.hbase.HBaseSerDe'
STORED BY
'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES (
'hbase.columns.mapping'=':key,info:index',
'serialization.format'='1')
TBLPROPERTIES (
'hbase.mapred.output.outputtable'='x:tuid_to_index',
'hbase.table.name'='x:tuid_to_index',
'transient_lastDdlTime'='1626835726')
When I use spark version 2.4.3 to search temp.mapping_from_hbase which can find
it, but use spark version 3.0.1 can not do it.
!screenshot-1.png!
> Spark ThriftServer does not search hive external table which storage in hbase
> -----------------------------------------------------------------------------
>
> Key: SPARK-36282
> URL: https://issues.apache.org/jira/browse/SPARK-36282
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: Yu Wang
> Priority: Major
> Attachments: screenshot-1.png
>
>
> hive version is 2.3.3, hbase version is 2.4.2;
> CREATE EXTERNAL TABLE `temp.mapping_from_hbase`(
> `tuid` string COMMENT '',
> `index` int COMMENT '')
> ROW FORMAT SERDE
> 'org.apache.hadoop.hive.hbase.HBaseSerDe'
> STORED BY
> 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
> WITH SERDEPROPERTIES (
> 'hbase.columns.mapping'=':key,info:index',
> 'serialization.format'='1')
> TBLPROPERTIES (
> 'hbase.mapred.output.outputtable'='x:tuid_to_index',
> 'hbase.table.name'='x:tuid_to_index',
> 'transient_lastDdlTime'='1626835726')
> When I use spark version 2.4.3 to search temp.mapping_from_hbase which can
> find it, but use spark version 3.0.1 can not do it.
> !screenshot-1.png!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
