Re: Speeding Up Group By Queries

Will the 10-100 million records get larger? Or is that just for a single user and you plan to have many users? If not, have you considered using a standard RDBMS like MySQL, Postgres, or Maria DB? Thanks, James On Tuesday, April 12, 2016, Amit Shah wrote: > Thanks James for

Re: SQL editor for Phoenix 4.4

That's good to hear, Randy, about Zeppelin. Thanks for letting us know. Do you think it'd make sense to bundle Zeppelin in our binary distro? What's the user experience like? James On Tuesday, April 12, 2016, Randy Gelhausen wrote: > You can also use Apache Zeppelin. > >

Re: SQL editor for Phoenix 4.4

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

Re: Speeding Up Group By Queries

Thanks James for the reply. Please see my comments below Secondary indexes[1] on the non-primary key columns is the way to improve > performance for these case. Take a look at this[2] presentation for more > detail. I have done a brief reading on secondary indexes and I will go through the

RE: SQL editor for Phoenix 4.4

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 Subject: SQL editor for Phoenix 4.4 Hi, I would like to know ,Is there SQL editor apart from Squirrel? Thanks, Divya

SQL editor for Phoenix 4.4

Hi, I would like to know ,Is there SQL editor apart from Squirrel? Thanks, Divya