Re: Kerberos and bulkload

2016-04-25 Thread Sanooj Padmakumar
Setting the below configuration in the MR made it work conf.set("hbase.coprocessor.region.classes", ""); Thanks everyone! On Tue, Apr 26, 2016 at 8:53 AM, Sanooj Padmakumar wrote: > Apologies if its against the convention to re-open an old discussion. > > The exception was resolved after I add

Re: Kerberos and bulkload

2016-04-25 Thread Sanooj Padmakumar
Apologies if its against the convention to re-open an old discussion. The exception was resolved after I added "conf.set("fs.permissions.umask-mode", "000");" as per the suggestion provided by Gabriel. However the same exception has re-surfaced again in a new kerberized cluster setup and I am una

Re: Extract report from phoenix table

2016-04-25 Thread Sanooj Padmakumar
Hi Ankit Thanks for the suggestion, this helps. I shall try that out. A new Output format on the lines of PhoenixOutputFormat and a new RecordWritable on the lines of PhoenixRecordWritable (and instead of writing using prepared statement, probably I can write it to file system) might do it Thanks

Re: Undefined column. columnName=IS_ROW_TIMESTAMP

2016-04-25 Thread Arun Kumaran Sabtharishi
Hi Ankit, Even though the ALTER TABLE SYSTEM.CATALOG ADD BASE_COLUMN_COUNT INTEGER, IS_ROW_TIMESTAMP BOOLEAN; statement threw an exception, it actually added the columns to the SYSTEM.CATALOG. But, the ./sqlline.py localhost;CurrentSCN=9 did not work. The current timestamp was not set to 9. Will t

Re: Failed to make the connection

2016-04-25 Thread Asanka Sanjaya Herath
Hi Steve, Thank you for the reply. I'm using cloudbreak and Ambari. On Mon, Apr 25, 2016 at 7:59 PM, Steve Terrell wrote: > Are you using Amazon EMR as your cluster? Are you trying to connect to > Phoenix on an EMR master or from outside the cluster? > > On Mon, Apr 25, 2016 at 8:25 AM, Asanka

Re: Failed to make the connection

2016-04-25 Thread Steve Terrell
Are you using Amazon EMR as your cluster? Are you trying to connect to Phoenix on an EMR master or from outside the cluster? On Mon, Apr 25, 2016 at 8:25 AM, Asanka Sanjaya Herath wrote: > I'm using simple phoenix hello world program in a amazon cluster. When I > run *./sqlline.py * it connects

Failed to make the connection

2016-04-25 Thread Asanka Sanjaya Herath
I'm using simple phoenix hello world program in a amazon cluster. When I run *./sqlline.py * it connects properly. But when I use the java program it gives me following error. I took the *phoenix-4.4.0.2.3.4.0-3485-client.jar* from phoenix installation directory and copied it to the class path. Sam

Re: Extract report from phoenix table

2016-04-25 Thread Ankit Singhal
Sanooj, It is not necessary that output can only be written to a table when using MR, you can have your own custom reducer with appropriate OutputFormat set in driver. Similar solutions with phoenix are:- 1. phoenix MR 2. phoenix spark 3. phoenix pig On Thu, Apr 21, 2016 at 11:06 PM, Sanooj Padm

Re: Undefined column. columnName=IS_ROW_TIMESTAMP

2016-04-25 Thread Ankit Singhal
Yes Arun, it seems fine to me. Can you do it for BASE_COLUMN_COUNT too so that the dependent features work correctly.(Remember use correct INTEGER byte representation for DATA_TYPE column). And, can you also please share output of > scan 'SYSTEM.SEQUENCE' Regards, Ankit On Fri, Apr 22, 2016 at 9