<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>

                ThinkChat2.0新版上線,更智能更精彩,支持會話、畫圖、視頻、閱讀、搜索等,送10W Token,即刻開啟你的AI之旅 廣告
                下面的任意數據導出方式的行為是復制,所以導出后Hive表中的數據還是存在的。 <br/> **1. `insert`方式導出** (1)`directory '/opt/datas/export/student'` 只能指定到目錄,不能指定導出到具體的文件; (2)導出的是Hive表實際對應的hdfs文件; (3)`/opt/datas/export/student` 目錄如果不存在,Hive會在本地自動創建; ```sql -- 將查詢的結果導出到本地 insert overwrite local directory '/opt/datas/export/student' select * from student; -- 將查詢的結果格式化后導出到本地 insert overwrite local directory '/opt/datas/export/student1' row format delimited fields terminated by '\t' collection items terminated by '\n' select * from student; -- 將查詢的結果導出到 hdfs 上,不寫 local 則是導入到hdfs insert overwrite directory '/user/hive/warehouse/student2' row format delimited fields terminated by '\t' collection items terminated by '\n' select * from student; ``` **2. hdfs命令導出到本地** ```sql hive (default)> dfs -get /user/hive/warehouse/student/month=201709/000000_0 /opt/datas/export/student3.txt; ``` **3. Hive Shell 命令導出** ```shell -- 將hive表的數據導出到本地的student.txt文件中 [root@hadoop101 /]# hive -e 'select * from table_name' > student.txt -- 執行student.sql里面的導出語句 [root@hadoop101 /]# hive -f 'student.sql` ``` **4. export導出到HDFS上** ```shell -- 將Hive表的數據導出到HDFS的/home/hadoop/目錄下 hive (default)> export table table_name to '/home/hadoop/'; hive (default)> export table table_namepartition (year=2018, month=9) to '/home/hadoop/'; ```
                  <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>

                              哎呀哎呀视频在线观看