Re: Map a huge HBase table to a Phoenix table

2016-06-19 Thread Randy Gelhausen
Hi Tongzhou, Please see the "Mapping to an Existing HBase Table" section on the landing page at phoenix.apache.org. It recommends creating a view on-top of the existing table instead of creating a new table. Thanks, -Randy On Sun, Jun 19, 2016 at 5:45 PM, Tongzhou Wang

Re: Replacing solr with pheonix for XML data

2016-04-14 Thread Randy Gelhausen
Hi Vikram, This question comes up somewhat often, so I'd be very interested in comments from other users of Solr and Phoenix as well. You'd need to either pre-parse fields from XML and save them as column values to use in queries, or use a UDF to dynamically parse XML stored within a single

Re: SQL editor for Phoenix 4.4

2016-04-12 Thread Randy Gelhausen
You can also use Apache Zeppelin. On Tue, Apr 12, 2016 at 3:24 AM, Bulvik, Noam wrote: > You can use also http://www.sql-workbench.net/ > > > > *From:* Divya Gehlot [mailto:divya.htco...@gmail.com] > *Sent:* Tuesday, April 12, 2016 10:15 AM > *To:* user@phoenix.apache.org