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

                合規國際互聯網加速 OSASE為企業客戶提供高速穩定SD-WAN國際加速解決方案。 廣告
                Phoenix Shell創建的表可以使用Hbase shell操作,但是Hbase shell 創建的表Phoenix Shell是看不到的。 <br/> ```sql -- 鍵表 -- 不支持 auto_increment自增 create table if not exists company( company_id integer primary key, name varchar(225) ); -- 查看表 0: jdbc:phoenix:hadoop101:2181> !tables -- 查看表的所有列 0: jdbc:phoenix:hadoop101:2181> !columns company -- 插入數據 -- 字符串只支持 '',不支持 "" upsert into company values(1, 'Microsoft'); upsert into company values(2, 'IBM'); -- 查詢數據 select * from company; +-------------+------------+ | COMPANY_ID | NAME | +-------------+------------+ | 1 | Microsoft | | 2 | IBM | +-------------+------------+ -- 刪除數據 delete from company where company_id=2; -- 建表 create table if not exists stock( company_id integer primary key, price decimal(10, 2) ); -- 插入數據 upsert into stock values(1, 124.9); upsert into stock values(2, 99); -- 表關聯 select s.company_id, c.name, s.price from stock s left outer join company c on s.company_id = c.company_id; +---------------+------------+----------+ | S.COMPANY_ID | C.NAME | S.PRICE | +---------------+------------+----------+ | 1 | Microsoft | 124.9 | | 2 | | 99 | +---------------+------------+----------+ -- 退出 0: jdbc:phoenix:hadoop101:2181> !quit ```
                  <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>

                              哎呀哎呀视频在线观看