<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question Re: How to create  phoenix view on existing HBase table by splitting primary key to composite keys in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/How-to-create-phoenix-view-on-existing-HBase-table-by/m-p/293345#M216647</link>
    <description>&lt;P&gt;according to this post：&lt;A href="https://phoenix.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table" target="_blank"&gt;https://phoenix.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table&lt;/A&gt;&lt;/P&gt;&lt;P&gt;you can do it like this, say that the existing HBase table is "t1" :&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;CREATE VIEW "t1"("col1" varchar not null,
    "col2" varchar not null,
    "col3" varchar not null,
    "col4" integer not null,
    "f"."c1" integer, 
    "f"."c2" integer, 
    CONSTRAINT "ROW" PRIMARY KEY("col1", "col2", "col3", "col4")
);&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Mon, 06 Apr 2020 10:14:45 GMT</pubDate>
    <dc:creator>Marks</dc:creator>
    <dc:date>2020-04-06T10:14:45Z</dc:date>
  </channel>
</rss>

