<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ??一站式輕松地調用各大LLM模型接口,支持GPT4、智譜、豆包、星火、月之暗面及文生圖、文生視頻 廣告
                **1. 創建 hivebook 數據庫** ```sql 0: jdbc:hive2://hadoop101:10000> create database hivebook; 0: jdbc:hive2://hadoop101:10000> create database if not exists hivebook; -- location 指定數據在hdfs上的存儲位置 0: jdbc:hive2://hadoop101:10000> create database if not exists hivebook location '/home/hive'; ``` **2. 選用 hivebook 數據庫** ```sql 0: jdbc:hive2://hadoop101:10000> use myhivebook; ``` **3. 查看 hivebook 數據庫的描述** ```sql -- (1)方式1 0: jdbc:hive2://hadoop101:10000> desc database hivebook; +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ | db_name | comment | location | owner_name | owner_type | parameters | +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ | hivebook | | hdfs://hadoop101:9000/home/hadoop/hive/warehouse/hivebook.db | root | USER | | +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ -- (2)方式2 0: jdbc:hive2://hadoop101:10000> describe database hivebook; +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ | db_name | comment | location | owner_name | owner_type | parameters | +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ | hivebook | | hdfs://hadoop101:9000/home/hadoop/hive/warehouse/hivebook.db | root | USER | | +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ -- (3)方式3 0: jdbc:hive2://hadoop101:10000> desc database extended hivbook; +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ | db_name | comment | location | owner_name | owner_type | parameters | +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ | hivebook | | hdfs://hadoop101:9000/home/hadoop/hive/warehouse/hivebook.db | root | USER | | +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ ``` **4. 改變 hivebook 數據庫的擁有者為 root** ```sql 0: jdbc:hive2://hadoop101:10000> alter database hivebook set owner user root; ``` 改變前為anonymouns擁有 ![](https://img.kancloud.cn/bb/66/bb662d34b388cd0c15da9871a37a7f78_1456x238.png) 改變后為root擁有。 <br/> **5. 刪除 hivebook2 數據庫** ```sql -- (1)方式1刪除:當數據庫為空時才能刪除 0: jdbc:hive2://hadoop101:10000> drop database if exists hivebook2; -- (2)方式2刪除:無論數據庫是否為空,強制刪除 0: jdbc:hive2://hadoop101:10000> drop database if exists hivebook2 cascade; ``` **6. 模糊查詢數據庫** ```sql 0: jdbc:hive2://hadoop101:10000> show databases like 'hive*'; +----------------+--+ | database_name | +----------------+--+ | hivebook | | hivedb | | hivedb2 | +----------------+--+ ``` **7. 查看當前所使用的數據庫** ```sql 0: jdbc:hive2://hadoop101:10000> select current_database(); +-----------+--+ | _c0 | +-----------+--+ | hivebook | +-----------+--+ ```
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看