+1 for only supporting Hadoop2 initially (great work, Jesse!). It's
important that Phoenix started implementing monitoring and metrics
features. An incremental approach is the way to go IMHO.
Thanks,
Eli
On Tue, Jul 1, 2014 at 11:13 AM, James Taylor
wrote:
> Seems like an excellent feature to
Kiru, only basic equality expressions are supported for creating updateable
views. Please file a Jira if you have specific requirements for supporting
more complex WHERE clauses in updateable views.
Thanks,
Eli
On Wed, Jul 9, 2014 at 4:48 PM, Kiru Pakkirisamy
wrote:
> Can't we not use even
Ashish,
Phoenix exposes this operation via sequences.
http://phoenix.apache.org/sequences.html
Thanks,
Eli
On Mon, Jul 28, 2014 at 10:57 AM, ashish tapdiya
wrote:
> How to perform atomic check and put operation on a phoenix table
>
s
> value as concurrent clients will be accessing it.
>
>
> On Mon, Jul 28, 2014 at 3:02 PM, Eli Levine wrote:
>
>> Ashish,
>>
>> Phoenix exposes this operation via sequences.
>> http://phoenix.apache.org/sequences.html
>>
>> Thanks,
>>
Dan, TenantId can be embedded directly into a URL used to establish
connections like this. e.g. jdbc:phoenix:localhost;TenantId=jan Note the
use of a semicolon after localhost.
On Tue, Aug 26, 2014 at 9:40 AM, Dan Di Spaltro
wrote:
> I've only ever used TenantId in the properties map, I didn't
Jan, thank you for reporting. Working on reproing now.
On Tue, Aug 26, 2014 at 10:50 AM, Eli Levine wrote:
> Dan, TenantId can be embedded directly into a URL used to establish
> connections like this. e.g. jdbc:phoenix:localhost;TenantId=jan Note the
> use of a semicolon after
Hi Pari,
Phoenix supports views in version 3.0 and higher only.
Thanks,
Eli
On Mon, Sep 29, 2014 at 12:08 AM, Pariksheet Barapatre wrote:
> Hi All,
>
> I am trying to create view on table given in phoenix website -
>
> CREATE TABLE product_metrics (
> metric_type CHAR(1) NOT NULL,
>
The EXPLAIN command should help.
http://phoenix.apache.org/language/index.html#explain
On Thu, Oct 23, 2014 at 5:40 AM xuxc1120 wrote:
> environment:
> hadoop-2.3.0-cdh-5.1.0
> hbase-0.98.1-cdh-5.1.0
> phoenix-4.1.0
>
> i have create a table in phoenix client ,and then create index on some
> col
You'd use with with a SELECT statement like this:
SELECT /*+ NO_CACHE */ COUNT(*) FROM TABLE1;
Eli
On Thu, Nov 13, 2014 at 4:50 AM, Pariksheet Barapatre
wrote:
> Hi All,
>
> Want to use NO_CACHE Hint , how to use it .
>
> Any example or documentation ?
>
> http://phoenix.apache.org/language/in
Guillermo, Phoenix by default puts columns into a CF named '_'. You can
specify a different CF when creating tables or columns like this:
mycf.col1, in which case Phoenix would put "col1" column into "mycf" CF,
creating it if necessary.
http://phoenix.apache.org/language/index.html#column_ref
Eli
Right. Thanks for the correction, James.
On Mon, Nov 24, 2014 at 8:51 AM, James Taylor
wrote:
> FYI, the default column family name is '0'
>
>
> On Monday, November 24, 2014, Eli Levine wrote:
>
>> Guillermo, Phoenix by default puts columns into a CF named
Phoenix stores VARCHAR and INTEGER values differently so your best bet is
to create a new INTEGER column and write a script to move data from the
VARCHAR column into the INTEGER column. If you are guaranteed that all data
in your VARCHAR column are indeed numbers you can do this with a single
SELEC
Yes, should be possible, since secondary indexes are themselves Phoenix tables.
> On Jan 25, 2015, at 5:42 AM, Lin Feng wrote:
>
> We have been using house grown secondary indexes on HBase tables in our
> application.
> I am wondering if we switch to Phoenix and let Phoenix creates and mainta
Have you looked at paging [1] using Phoenix's row-value constructors
together with the LIMIT clause? That might be what you are looking for.
[1] http://phoenix.apache.org/paged.html
Eli
On Mon, May 18, 2015 at 6:46 AM, Isart Montane
wrote:
> Hi,
>
> the company I work for is performing some t
more generic answer I can apply to the driver/phoenix since that
> will require me lots of changes to the code.
>
> Any clue on why it works with sqline but not trough the node driver?
>
> On Mon, May 18, 2015 at 4:20 PM, Eli Levine wrote:
>
>> Have you looked at pag
{
>> > for (int i = 1; i <= numberOfColumns; i++) {
>> > lsRows.add(rs.getString(i));
>> > }
>> > lsResults.add(join("\t", lsRows));
>> > lsRows.clear();
>> > }
>> > rs.close();
>> >
To add to Vladimir's comments, I'd suggest using DATE instead of LONG for
(4). This way you'll be able to take advantage of Phoenix's support for
date functions should you need to do so in the future.
Eli
On Mon, Jul 6, 2015 at 11:32 AM, Vladimir Rodionov
wrote:
> 1. Unless you do query by Anum
The standard JDBC way is to use Connection.getMetadata(). See if that does what
you need. You can also query SYSTEM.TABLE directly via Phoenix if you know what
you are doing.
> On Jul 13, 2015, at 4:57 PM, Kevin Verhoeven
> wrote:
>
> Is there a way to query the table structure of user tab
visibility into Phoenix internals.
Look forward to continuing working with Jan on Apache Phoenix!
Thanks,
Eli Levine
elilev...@apache.org
Hi Gaurav,
Phoenix provides a way for multiple tenants to share a single table by
automatically sharding the tablespace by tenant id. This is done via
tenant-specific views. You should create a multi-tenant table over a
regular connection (no TenantId). When you open a tenant-specific
connection (
in where clause of a select query
> it is taking the connection tenantid and append it .
> On Mar 1, 2016 10:25 PM, "Eli Levine" wrote:
>
>> Hi Gaurav,
>>
>> Phoenix provides a way for multiple tenants to share a single table by
>> automatically shardin
Hi Sudipta,
This is a good high-level overview of Phoenix’s multi-tenancy: https://
phoenix.apache.org/multi-tenancy.html
Are you looking for more info than what’s on that page?
CC’ing user@phoenix, since this might be useful to others.
Thanks,
Eli
On Wed, Oct 4, 2017 at 10:28 PM, sudipta da
-tenant jdbc
> connection is established?
>
> Also, does it partition the data in back-end once we load a multi- tenant
> table?
>
> How about the performance of a multi-tenant table?
>
> Kindly provide your valuable response.
>
> Thanks,
> Sudipta
>
> On 6 Oct 2017 11:
23 matches
Mail list logo