Bulk dataload and dynamic columns

Hi All, Can we populate dynamic columns as well while bulk loading data ( https://phoenix.apache.org/bulk_dataload.html) into Hbase using Phoenix ? It didn't work when we tried and hence posting it here. Thanks in advance -- Thanks, Sanooj Padmakumar

Re: Which statements are supported when using transactions?

Francis, Can you please file a JIRA for this? Thanks, Thomas On Thu, Oct 6, 2016 at 12:58 AM, F21 wrote: > I just ran into the following scenario with Phoenix 4.8.1 and HBase 1.2.3. > > 1. Create a transactional table: CREATE TABLE schemas(version varchar not > null

Re: Hash join confusion

Assigned. Thanks a lot for filing the issue, Sumit! On Thu, Oct 6, 2016 at 10:19 AM, Sumit Nigam wrote: > Hi Maryann, > > I created https://issues.apache.org/jira/browse/PHOENIX-3354 for this > issue. I could not assign to you. > > Best regards, > Sumit > >

Re: Hash join confusion

Hi Maryann, I created https://issues.apache.org/jira/browse/PHOENIX-3354 for this issue. I could not assign to you. Best regards,Sumit From: Maryann Xue To: "user@phoenix.apache.org" ; Sumit Nigam Sent: Wednesday,

Re: Recover from "Cluster is being concurrently upgraded from 4.7.x to 4.8.x"

Patrick, Do you have multiple 4.8.1 clients connecting to the cluster at the same time? On Thu, Oct 6, 2016 at 8:11 AM, Patrick FICHE wrote: > Hi, > > I upgraded Phoenix server from 4.7.0 to 4.8.1 on HDP cluster. > > Now, when I try to connect to my server using

RE: Jdbc connection issue

I was able to resolve this, after adding the hdfs/hbase/core sites.xml to classpath. V From: Kondadasula, Vikram: IT (NYK) Sent: Wednesday, October 05, 2016 3:16 PM To: user@phoenix.apache.org Subject: Jdbc connection issue Hi, I am trying to connect to phoenix using jdbc and getting the

Creating view on a phoenix table throws Mismatched input error

Hi, I have a table on top of a Hbase table as follows: create table "tsco" (PK VARCHAR PRIMARY KEY, "stock_daily"."Date" VARCHAR, "stock_daily"."close" VARCHAR, "stock_daily"."high" VARCHAR, "stock_daily"."low" VARCHAR, "stock_daily"."open" VARCHAR, "stock_daily"."ticker" VARCHAR,

Can I change a String column's size and preserve the data?

I have a column on a table that is set to varchar(40). I need to increase that 40, but I don't want to lose any of the data in the table. The only suggestions I've seen online involve dropping the column and re-creating it, or creating a new table. But I would like to preserve the name of

Recover from "Cluster is being concurrently upgraded from 4.7.x to 4.8.x"

Hi, I upgraded Phoenix server from 4.7.0 to 4.8.1 on HDP cluster. Now, when I try to connect to my server using sqlline.py from 4.8.1, I get the error "Cluster is being concurrently upgraded from 4.7.x to 4.8.x". However, I'm still able to connect to the server using sqlline.py from 4.7.0

Which statements are supported when using transactions?

I just ran into the following scenario with Phoenix 4.8.1 and HBase 1.2.3. 1. Create a transactional table: CREATE TABLE schemas(version varchar not null primary key) TRANSACTIONAL=true 2. Confirm it exists/is created: SELECT * FROM schemas 3. Begin transaction. 4. Insert into schemas: