Re: Re: Phoenix tracing

2015-04-02 Thread Fulin Sun
Hi, there In your regionserver side logs, can you find something related with phoenix tracing ? If not, I assume you still had configs wrong placed. Thanks, Sun. CertusNet From: ashish tapdiya Date: 2015-04-03 09:38 To: user Subject: Re: Phoenix tracing Hi Sun, hbase-site.xml is alread

Re: Phoenix tracing

2015-04-02 Thread ashish tapdiya
Hi Sun, hbase-site.xml is already in bin directory and the directory is on classpath Thanks, ~Ashish On Thu, Apr 2, 2015 at 8:13 PM, Fulin Sun wrote: > Hi, > > Maybe you want to put your client side hbase-site.xml into phoenix bin > directory. > > I once encountered such problem and doing that

Re: Phoenix tracing

2015-04-02 Thread Fulin Sun
Hi, Maybe you want to put your client side hbase-site.xml into phoenix bin directory. I once encountered such problem and doing that just resolved it. Thanks, Sun. CertusNet From: ashish tapdiya Date: 2015-04-03 04:53 To: user Subject: Phoenix tracing Hi, I am trying to setup tracing

Re: Phoenix sqlline command !tables issue

2015-04-02 Thread Sergey Belousov
!set incremental false in sqlline also could help On Apr 2, 2015 4:20 PM, "ashish tapdiya" wrote: > Gabriel, > > Thanks, that did it. > > ~Ashish > > On Thu, Apr 2, 2015 at 3:02 PM, Gabriel Reid > wrote: > >> Hi Ashish, >> >> The other columns are being cut off by the size of your terminal windo

Re: bulk loader MR counters

2015-04-02 Thread James Taylor
You may also want to take a look at tuning phoenix.stats.guidepost.width or phoenix.stats.guidepost.per.region as these may impact how many mapper tasks you end up with. See http://phoenix.apache.org/tuning.html and http://phoenix.apache.org/update_statistics.html for more information. A quick test

RE: bulk loader MR counters

2015-04-02 Thread Perko, Ralph J
Thanks - I will try your suggestion. Do you know why there are so some many more output than input records on the main table (39x more). From: Ravi Kiran [mailto:maghamraviki...@gmail.com] Sent: Thursday, April 02, 2015 2:35 PM To: user@phoenix.apache.org Subject: Re: bulk loader MR counters Hi

RE: bulk loader MR counters

2015-04-02 Thread Perko, Ralph J
My apologies, the formatting did not come out as planned. Here is another go: Hi, we recently upgraded our cluster (Phoenix 4.3 - HDP 2.2) and I'm seeing a significant degradation in performance. I am going through the MR counters for a Phoenix CsvBulkLoad job and I am hoping you can help me u

Re: bulk loader MR counters

2015-04-02 Thread Ravi Kiran
Hi Ralph. I assume when you are running the MR for the main table, you have a larger number of columns to load than the MR for the index table due to which you see more spilled records. To tune the MR for the Main table, I would do the following first and then measure the counters to see for

Phoenix tracing

2015-04-02 Thread ashish tapdiya
Hi, I am trying to setup tracing following the steps specified on the Phoenix webpage, http://phoenix.apache.org/tracing.html Below are the steps I have followed, 1. On the client, property files (hadoop-metrics2-phoenix.properties and hadoop-metrics2-hbase.properties) came configured with the

bulk loader MR counters

2015-04-02 Thread Perko, Ralph J
Hi, we recently upgraded our cluster (Phoenix 4.3 – HDP 2.2) and I’m seeing a significant degradation in performance. I am going through the MR counters for a Phoenix CsvBulkLoad job and I am hoping you can help me understand some things. There is a base table with 4 index tables, so a total o

Re: Phoenix sqlline command !tables issue

2015-04-02 Thread ashish tapdiya
Gabriel, Thanks, that did it. ~Ashish On Thu, Apr 2, 2015 at 3:02 PM, Gabriel Reid wrote: > Hi Ashish, > > The other columns are being cut off by the size of your terminal window. > If you make your window larger, you'll be able to see the additional > columns. > > - Gabriel > > > On Thu, Apr

Re: Phoenix sqlline command !tables issue

2015-04-02 Thread Gabriel Reid
Hi Ashish, The other columns are being cut off by the size of your terminal window. If you make your window larger, you'll be able to see the additional columns. - Gabriel On Thu, Apr 2, 2015 at 9:46 PM ashish tapdiya wrote: > I am issuing command "!tables" using sqlline to see all tables. Th

Phoenix sqlline command !tables issue

2015-04-02 Thread ashish tapdiya
I am issuing command "!tables" using sqlline to see all tables. The result shows a table with two columns (TABLE_CAT, TABLE_SCHEM) and a large number of blank rows (most likely number of rows correspond to number of tables but no textual names). However, I can query the created tables fine. I am