Flink实战（八十四）：flink-sql使用（十一）Flink 与 hive 结合使用（三）Hive Dialect

王知无(import_bigdata)

已于 2022-07-05 20:23:25 修改

阅读量1k

点赞数

分类专栏： Flink系统性学习专栏文章标签： hive flink sql

于 2021-01-23 15:05:02 首次发布

原创文章禁止转载。否则追究法律后果。

本文链接：https://blog.csdn.net/u013411339/article/details/113049966

版权

Flink系统性学习专栏专栏收录该内容

256 篇文章 102 订阅 ¥39.90 ¥99.00

订阅专栏

超级会员免费看

本文介绍了Flink从1.11.0版本开始支持Hive方言，允许用户使用Hive语法编写SQL语句，增强与Hive的互操作性。内容涵盖如何在SQL Client和Table API中切换Hive方言，以及Hive方言支持的DDL、DML、DQL操作，并提醒了使用Hive方言应注意的事项。

摘要由CSDN通过智能技术生成

1 Hive Dialect

Starting from 1.11.0, Flink allows users to write SQL statements in Hive syntax when Hive dialect is used. By providing compatibility with Hive syntax, we aim to improve the interoperability with Hive and reduce the scenarios when users need to switch between Flink and Hive in order to execute different statements.

2 Use Hive Dialect

Flink currently supports two SQL dialects: default and hive. You need to switch to Hive dialect before you can write in Hive syntax. The following describes how to set dialect with SQL Client and Table API. Also notice that you can dynamically switch dialect for each statement you execute. There’s no need to restart a session to use a differ

了解本专栏