Hi,
The process which we followed is as :
1. Clone a hbase snapshot to a table
2. Create schema in phoenix for new table
3. Create index for the table.
When I query the data, this is what I'm getting:
select /*+ NO_INDEX */ count(*) from "schema".CUSTOMERS where "id"=1234;
+------------------------------------------+
| COUNT(1) |
+------------------------------------------+
| 0 |
+------------------------------------------+
1 row selected (0.236 seconds)
select * from "smf1".CUSTOMERS where "id"=1234;
+------------------------------------------+----------------
--------------------------+---------------------------------
---------+------------------------------------+
| id | lgcyId
| lgcyMrnId |
nme |
+------------------------------------------+----------------
--------------------------+---------------------------------
---------+------------------------------------+
+------------------------------------------+----------------
--------------------------+---------------------------------
---------+------------------------------------+
No rows selected (0.153 seconds)
select * from "smf1".CUSTOMERS;
| 1234 | 4ebaa3f8404dbffe28000000 | | Performads
// for 1234 customer, the data is present in hbase.
Can someone please help or give suggestions, as to why the data is not
showing when the data is present and index has been updated ? Thank you.
--
Great Day,
Karunakar.UV
lkarunaka...@gmail.com
