dbeaver连接hbase时间戳查询
用dbeaver连接hbase时间戳查询时,不能用vachar或者直接写时间戳,报错类型不匹配。经过测试,需要用TO_TIMESTAMP转换对应vachar类型时间,可以正常查询。样例如下: SELECT "company_id" AS "companyId", "score_overall" AS "scoreOverall" FROM CEM_DEV_COMPANY.COMPANY_NET_PERFORMANCE_BY_DAY WHERE "eve
原创
2020-10-26 17:23:36 ·
1143 阅读 ·
0 评论