My version is 2.2.3. I downloaded from
http://www.carfab.com/apachesoftware/incubator/phoenix/ . Where can I see
the 3.0 version?
I created and populated a table "TestTable" with HBase's
PerformanceEvaluation tools. I am able to create a view of TestTable with
no error reported. But if I do a select * from TestTable; the value are
all shown as null, but if I do a hbase scan, the val are not null. Does
this mean view is not created correctly?
*+------------+------------+*
*| ** PK ** | ** VAL ** |*
*+------------+------------+*
*| *0002880099* | *null * |*
*| *0002880100* | *null * |*
*| *0002880101* | *null * |*
*| *0002880102* | *null * |*
*| *0002880103* | *null * |*
*| *0002880104* | *null * |*
*| *0002880105* | *null * |*
*| *0002880106* | *null * |*
*| *0002880107* | *null * |*
*HBase scan result of one row:*
0000000025 column=info:data, timestamp=1395695767435,
value=V+`(\xB4\
xC5@
\xE5\xAAV\x8FO\xB3\x93\xD8a\x00\xD9\xED\xA3U\xD3\x1B\x
C5\x9E\x9C\xF1@
\xB2\x1A\x028'\xF2\xB0Xr\x8D\xEE\x99s?\xE9T
\xF5\xA18\xFE\xD2\x17\x8D\x1E\x91QDl\xB0\xFDZ{\xB1Y|\x15\x
B4\x13\xFF\xE0\xED\x5C\x8E\x13\xCF\x13\xECoJ\x1EK9\xD2\x0C
{lC\x8E\xBB\x09\x88;4\xB1N@
\xF1\xF5h\xE2fO\xEE\xF0\xA9\xA5
U\xDBy\xF4\xA4W\x0AH\x0D\xD1\xA4M1e\xBDR2*\x831\x04\x96_{\
x15\xC6@
\x9E\xD3\xF9\xC7$\xA5KoI\xA9L4\x906\x05\x15'\xF1\x
CA%\x15\xFD\xA76YE\x99\xE8\x01m\x04a@
\x0Fz\xB7A\xDE\x04\xA
2\x9C5n\xE5{"\xA2\x97to\x93\x83\xFD\xFC!|\xC5\xF6iD\x09\x8
A\x19X\xCD\xA6txF%\xDE\xB9<\xD61\xD9{LY\xD7\xCFk\x88M\xF9\
x85(\x91\x94\xEECi\xFFg\xA05w\xB2\xEB\x1B\xAD%B7\xB3Ot:\x1
9R\x85\x96\x8C\xF9\xCF3\x99\xB4\x13\x83\xE2z\x89\xEF1d\xCB
\x8Fa\xE0.5\xFA\x8A\x9B8\xF1\x16\xAC-kv\xAA\xE5{\xFF\xA2\x
C7\x9C\xE9\xB7\x8E+\xDC\x9D\xFC\x12\xC6l\xD1g\xF3y\xB6\x1D
\x85\xD1\xD0\xE1\xD5\xEB~\xDF\x1D\x87y\x02\xBAS\xF3\xFDF*\
x12\x02\xC7\x8F\xBE\x0D4\x8F\x10\xDF@
\xE3R^K\xD4\x00}\xEC\
xB4\x1D\x09S\xB4\x82P9\xA4\xFCg2\x95B\x92\xE5\x93\xC2\xDD;
\x9E\xEFe1\x9A\xBF|\x969\xA6\x06\xED\x99P\x12F\xD6\xA83\xE
0l\x0B\x03\xD8\x1C\x18\xC2QO\xB0\xBB\xCB\x1EK\xE3\xC3unM"\
xE9\xF0|\x1F\xB1\xCA\x83\xC7\x5C\x0B\xAE\xE7\x92n\xE2\xA9\
xD3!X\x1D\xF23\xB9\xB9\xF7\xB5j\x07\xD3\x9B\x801\xD91Z\xFD
\xD6\x0CM\xCC\xD3i7\xD9N\x191\xD6\xBE3x\xCE!!U;J\x06\xDC\x
A4\xC3\xC9\xB1\x08\xDB\x14\xB6\xB4\xC0\xBC]\xF0\xC3\xD5O\x
16\xC3\x12m\xD6\xEA
\xF1\xDB\xB3\x18\xA8o\xDAt\xB9S\x8C\x0
2!pw\x97\x82\xA8\xDE\xDB\xAA\xF2"\x90\xD5Q\xE2\xD1\x9F\xE6
\x8F\xF3J18;\x89\xD4\x07\x11\xDEbs|\xA95\xDBN\x19\xEF\x0E\
x08.2T\xF4a\x12\xA6\xBF\x86\x84FUA\xB2S\xB2\xB1\xCEU\x8Bt2
\xDFx\xA2\xAA\xD3\xCE\x8D\xD4\x1F0H7\xB9\x92\xCB4\x95Y\x0C
\xF4K\x19Z\xB1\xEA\x1A5&\x84\x98\xCC\xB9\xC4xX$\xDBCBV"f\x
F4+\xD2\xDC\xCDh\x9A\xAEG\xBB\xD6\x1A\x94w\x1B\x1A\x9C\x88
7os\x01f
\xB6{5\x92\x0B\xA6\x8C\xB9b]\xEE\x04\xC1\xB1*0u&{
\xE1\xBE\xC2\x08\xA7\x8D\x042"B\xA7`d\x85\x8C\x1C\x8C\xCA\
xAD,C\xE6\xBEl\xF3>\xE6\xBB\x11\x01\xC4\x9F\xBD\xE7At\xD3:
\x8E\x1B\xD9\xEA]\x0C\xDAj\xB9\xFC\x10\xC0\x83\xEA\xCC\x9C
e\x8Cs\x8C4\x8B\xB0\xC8\xE8\x01Om\x19)\x1D\xB0~\xDA)\xECh)
E^g\xC1'\x0A\xF9Z\xBF\xD9\x0B\xCD\xF9\x9F\x99\xB3\xBD-(J\x
A7\xB6c6\x92\xC6\x11|\x14\xB8"\xDF\xBC\xEC~1f\xA8\x10"?)\x
90\xDF\xA5\xA9j\x94$s\xE1\xB0z?\xAB\xF9Q\xAE\xE6\xACcJy\x0
A\x02\x02\xED[7\x1E\x80%\xA4\xB3t&b\x12\xCE\x87\xE7
\xB0\x
B2\x10\xA7s\xF94\xF3\x81\xC1s`n\xDC\xE0O$\x14\xD3I2\x8F\xB
4\xE4^\xC6B\x02@
\xE9l\xD9\xFA\xD4\xE6\xB3\xAE\x8F\xA5k\xCB
N\xA2\x02\x98\xC8\xB7\xAB\x99~\xF8N\xC6\x9FM}\x99F\x86\xA0
\x11l\xF6\x1Fez7\xCAEd\xF3\xB8\x90R\xE8\x15\x9F\xC3}\xE3D\
xAD\xBD\x84\x0EQd\xA1\x92\xC1\xD9i\xE3\xC1<\x0D]\xC7\xD6'\
x95\xB7\xAB\xDF\x00\xEC`:\xC1\xD1\xE1\x9C"L\x06.\x91\xC8\x
87\x07[\xA5\xC2+/\x91i\xD4\x90\x96\x17T\xEF|\xC0\x05.\xA4\
xBEQP\xE5]\xCA\xB5]sd\x09\x9AO*+\x04Pn\xC0\xBB\xE9Gr}\xAA\
x96\x17E\x88\x93\x94F\xF1\xA61\x0DW#\x82\x07\xDE\x05\xE5\x
D9_?\xDCtuW6\xF5\xD1B\xBA\xE0\xA8\xF4\xC6\xF8\xE0\xCB\x8DI
~\xD6^\xF3\xA4\xD5
On Fri, Mar 21, 2014 at 9:06 PM, James Taylor <[email protected]>wrote:
> Hi Tianying,
> Not sure what version you're using, but I recommend you use the latest
> release candidate [1]. If you've been playing around with earlier 3.0
> version, then it's best if you disable and drop the system table through
> the HBase shell, as it's been through various changes:
> disable 'SYSTEM.CATALOG'
> drop 'SYSTEM.CATALOG'
> Phoenix will automatically create this table when you connect the first
> time.
>
> I tried creating an HBase table in the HBase shell and then creating a
> view in Phoenix and dropping the view, and it worked fine.
>
> From the HBase shell:
> create 'foo', {NAME => 'f1'}
> put 'foo', 'r1','f1','value'
>
> From the Phoenix sqlline:
> create view "foo"(k varchar primary key, "f1". "value" varchar);
> select * from "foo";
> drop view "foo";
>
> Note that when you map a Phoenix table to an existing HBase table, the
> table name and column family name must match exactly. Otherwise Phoenix
> will give you an error message, because a view on an existing HBase table
> is considered read-only.
>
> HTH,
> James
>
>
> [1]
> http://mail-archives.apache.org/mod_mbox/incubator-phoenix-dev/201403.mbox/%3CCAAF1JdiBkqtR9FkEow-kGd1xsxZ%2B0B1-7NejH%3Duygocx_iM30g%40mail.gmail.com%3E
>
>
> On Fri, Mar 21, 2014 at 5:55 PM, Tianying Chang <[email protected]> wrote:
>
>> I tried to Drop view, it complains undefined, but if I try to create the
>> view, it will complain already exist. Any idea?
>>
>>
>> 0: jdbc:phoenix:hbasetestzk001a.ec2.pin220.co> CREATE VIEW "TestTable"
>> ( pk VARCHAR PRIMARY KEY, "info".val VARCHAR );
>>
>> Error: ERROR 1013 (42M04): Table already exists. tableName=TestTable
>> (state=42M04,code=0)
>>
>> 0: jdbc:phoenix:hbasetestzk001a.ec2.pin220.co> DROP VIEW "TestTable";
>>
>> Error: ERROR 1012 (42M03): Table undefined. tableName=TestTable
>> (state=42M03,code=1012)
>>
>>
>> On Fri, Mar 21, 2014 at 5:13 PM, Tianying Chang <[email protected]>wrote:
>>
>>> That works. Thanks
>>>
>>> Tian-Ying
>>>
>>>
>>> On Fri, Mar 21, 2014 at 5:01 PM, James Taylor <[email protected]>wrote:
>>>
>>>> Hi Tianying,
>>>> Try with our new 3.0 release candidate (
>>>> http://mail-archives.apache.org/mod_mbox/incubator-phoenix-dev/201403.mbox/%3CCAAF1JdiBkqtR9FkEow-kGd1xsxZ%2B0B1-7NejH%3Duygocx_iM30g%40mail.gmail.com%3E).
>>>>
>>>>
>>>> Follow the examples here:
>>>> http://phoenix.incubator.apache.org/views.html
>>>>
>>>> Please note that Phoenix upper cases table, column, and column family
>>>> names. So if your HBase table metadata isn't all uppercase, you need to put
>>>> these names in double quotes as the FAQ outlines.
>>>>
>>>> Thanks,
>>>> James
>>>>
>>>>
>>>> On Fri, Mar 21, 2014 at 4:54 PM, Tianying Chang <[email protected]>wrote:
>>>>
>>>>> Hi, Mujtaba
>>>>>
>>>>> Thanks for the quick response.
>>>>>
>>>>> I tried that, but got error below
>>>>>
>>>>> CREATE VIEW TestTable ( pk VARCHAR PRIMARY KEY, info.val VARCHAR );
>>>>>
>>>>> Error: ERROR 505 (42000): Table is read only. (state=42000,code=0)
>>>>>
>>>>>
>>>>> On Fri, Mar 21, 2014 at 4:19 PM, Mujtaba Chohan <[email protected]>wrote:
>>>>>
>>>>>> Hi Tian,
>>>>>>
>>>>>> Following page describes how you can use existing tables with Phoenix
>>>>>> http://phoenix.incubator.apache.org/faq.html#How_I_create_Views_in_Phoenix_Whats_the_difference_between_ViewsTables
>>>>>>
>>>>>> //mujtaba
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Fri, Mar 21, 2014 at 4:07 PM, Tianying Chang <[email protected]>wrote:
>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> I have put the phoenix jar under the hbase/lib. and tested that I
>>>>>>> can create a new table with sqlline, and do the select * statement.
>>>>>>>
>>>>>>> My question is how can I convert the existing HBase table to run
>>>>>>> those select commands? I have a HBase table that already has large
>>>>>>> amount
>>>>>>> of data in it.
>>>>>>>
>>>>>>> Thanks
>>>>>>> Tian-Ying
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
