<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之旅 廣告
                ●▲● `explode(array)` -- 返回n行,每行對應數組中的一個元素 示例1: ```sql 0: jdbc:hive2://hadoop101:10000> select explode(array(1,2,3,4)); +------+--+ | col | +------+--+ | 1 | | 2 | | 3 | | 4 | +------+--+ ``` 示例2: (1)準備數據`course.txt` ```txt 1,zhangsan,數學:語文:英語:生物 2,lisi,數學:語文 3,wangwu,化學:計算機:java ``` (2)建表 ```sql create table course( uid string, name string, kc array<string> ) row format delimited fields terminated by ',' collection items terminated by ':'; ``` (3)加載數據到表中 ```sql 0: jdbc:hive2://hadoop101:10000> load data local inpath '/opt/software/source/course.txt' into table course; ``` (4)查看數據 ```sql 0: jdbc:hive2://hadoop101:10000> select uid, name, kc[0] from course; +------+-----------+------+--+ | uid | name | _c2 | +------+-----------+------+--+ | 1 | zhangsan | 數學 | | 2 | lisi | 數學 | | 3 | wangwu | 化學 | +------+-----------+------+--+ ``` (5)將一個數組變成一列 ```sql 0: jdbc:hive2://hadoop101:10000> select explode(kc) from course where uid=1; +------+--+ | col | +------+--+ | 數學 | | 語文 | | 英語 | | 生物 | +------+--+ ``` ●▲● `explode(map)` -- 返回n行2列,每行對應每個map的k/v,第一列是map的k;第二列是map的v。 ```sql 0: jdbc:hive2://hadoop101:10000> select explode(map(1,2,3,4)); +------+--------+--+ | key | value | +------+--------+--+ | 1 | 2 | | 3 | 4 | +------+--------+--+ ``` ●▲● `json_tuple(jsonStr, k1, k2, ...)` -- 從一個JSON字符串中獲取多個key對應的value,并作為一個元組返回 ●▲● `parse_url_tuple(url, p1, p2,...)` -- 返回字符串URL中抽取指定N部分的內容,并作為一個元組返回;p1、p2就是抽取的部分
                  <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>

                              哎呀哎呀视频在线观看