Re: ABORTING region server and following HBase cluster "crash"

2018-09-08 Thread Ted Yu
It seems you should deploy hbase with the following fix: HBASE-21069 NPE in StoreScanner.updateReaders causes RS to crash 1.4.7 was recently released. FYI On Sat, Sep 8, 2018 at 3:32 PM Batyrshin Alexander <0x62...@gmail.com> wrote: > Hello, > > We got this exception from *prod006* server > >

Re: local index turn disable when region split

2017-11-03 Thread Ted Yu
Can you give us more information ? Release of hbase and Phoenix you use bq. The local index turn disable Can you pastebin the related exception(s) ? Snippet from region server log would also help. On Thu, Nov 2, 2017 at 11:31 PM, vergil wrote: > Hi,all: > > > Here is my test table. > *create

Re: Phoenix 4.12 error on HDP 2.6

2017-10-25 Thread Ted Yu
Since you're deploying onto a vendor's platform, I suggest asking this question on the vendor's forum. Cheers On Wed, Oct 25, 2017 at 3:59 AM, Sumanta Gh wrote: > Hi, > I am trying to install phoenix-4.12.0 (HBase-1.1) on HDP 2.6.2.0. As per > installation guide, I have copied the phoenix-4.12.

Re: [ANNOUNCE] New PMC Member: Sergey Soldatov

2017-09-24 Thread Ted Yu
Congratulations, Sergey ! On Sun, Sep 24, 2017 at 1:00 PM, Josh Elser wrote: > All, > > The Apache Phoenix PMC has recently voted to extend an invitation to > Sergey to join the PMC in recognition of his continued contributions to the > community. We are happy to share that he has accepted this

Re: Phoenix CSV Bulk Load fails to load a large file

2017-09-06 Thread Ted Yu
bq. hbase.bulkload.retries.retryOnIOException is disabled. Unable to recover The above is from HBASE-17165. See if the load can pass after enabling the config. On Wed, Sep 6, 2017 at 3:11 PM, Sriram Nookala wrote: > It finally times out with these exceptions > > ed Sep 06 21:38:07 UTC 2017, Rp

Re: org.apache.hadoop.hbase.regionserver.wal.DamagedWALException: Append sequenceId=8689

2017-07-06 Thread Ted Yu
outstanding appends; closing > WAL: org.apache.hadoop.hbase.regionserver.wal.DamagedWALException: Append > sequenceId=7846, requesting roll of WAL > 2017-07-06 19:48:39,261 INFO > [regionserver/ip-10-74-5-153.us-west-2.compute.internal/10. > 74.5.153:16020.logRoller] > wal.FSHLog: Roll

Re: org.apache.hadoop.hbase.regionserver.wal.DamagedWALException: Append sequenceId=8689

2017-07-06 Thread Ted Yu
HBASE-16960 mentioned the following : Caused by: java.net.SocketTimeoutException: 2 millis timeout while waiting for channel to be ready for read Do you see similar line in region server log ? Cheers On Thu, Jul 6, 2017 at 1:48 PM, anil gupta wrote: > Hi All, > > We are running HBase/Phoe

Re: Specify maven dependency

2017-06-29 Thread Ted Yu
Woo > Sent with Sparrow <http://www.sparrowmailapp.com/?sig> > > On Thursday, June 29, 2017 at 9:37 PM, Ted Yu wrote: > > Can you add -X to mvn command and pastebin the output? > > Ghanks > > Original message > From: Juvenn Woo > Date: 6/29/17

Re: Specify maven dependency

2017-06-29 Thread Ted Yu
Can you add -X to mvn command and pastebin the output? Ghanks Original message From: Juvenn Woo Date: 6/29/17 6:26 AM (GMT-08:00) To: user@phoenix.apache.org Subject: Specify maven dependency Hi all, For convenience of de

Re: I got a very weird message from user@phoenix.apache.org

2017-02-20 Thread Ted Yu
s spam trigger but did not hit the ASF's > spam trigger. > > This triggers the mailing list to tell you that a message it tried to send > you was rejected. So, you get a warning about a message that you never saw > in the first place. > > But, as Ted says, just ignore it. &

Re: I got a very weird message from user@phoenix.apache.org

2017-02-20 Thread Ted Yu
I received such message as well. You can ignore it. > On Feb 20, 2017, at 5:46 AM, Cheyenne Forbes > wrote: > > Hi! This is the ezmlm program. I'm managing the > user@phoenix.apache.org mailing list. > > > Messages to you from the user mailing list seem to > have been bouncing. I've attach

Re: Can I use protobuf2 with Phoenix instead of protobuf3?

2017-02-13 Thread Ted Yu
Phoenix uses protobuf 2.5 >From pom.xml : 2.5.0 FYI On Mon, Feb 13, 2017 at 4:52 PM, Cheyenne Forbes < cheyenne.osanu.for...@gmail.com> wrote: > my project highly depends on protobuf2, can I tell phoenix which version > of protobuf to read with when I am sending a request? >

Re: Query TimeOut on Azure HDInsight

2017-02-10 Thread Ted Yu
Sumanta: bq. at region=TABLE1,,1450429763940.e30cec826e39df2e3b21e0baa6e1d9c0., Please check the log of region server which hosted the above region around the time of your query. Which Phoenix / hbase release are you using ? Thanks On Fri, Feb 10, 2017 at 6:31 AM, Mark Heppner wrote: > Sumant

Re: Accessing Phoenix table from Spark 2.0., any cure!

2016-10-24 Thread Ted Yu
HBaseConfiguration is in hbase-common module. See if hbase-common jar is on the classpath. On Mon, Oct 24, 2016 at 8:22 AM, Mich Talebzadeh wrote: > My stack is this > > Spark: Spark 2.0.0 > Zookeeper: ZooKeeper 3.4.6 > Hbase: hbase-1.2.3 > Phoenix: apache-phoenix-4.8.1-HBase-1.2-bin > > I am r

Re: Load into Phoenix table via CsvBulkLoadTool cannot find table and fails

2016-10-23 Thread Ted Yu
Looks like user experience can be improved (by enriching exception message) if table abc can be found but table ABC cannot be found. Cheers On Sun, Oct 23, 2016 at 9:26 AM, Mich Talebzadeh wrote: > Thanks gents > > I dropped and recreated the table name and columns in UPPERCASE as follows: > >

Re: Index in Phoenix view on Hbase is not updated

2016-10-22 Thread Ted Yu
The first statement creates index, not view. Can you check ? Cheers > On Oct 22, 2016, at 1:51 AM, Mich Talebzadeh > wrote: > > Hi, > > I have a Hbase table that is populated via > org.apache.hadoop.hbase.mapreduce.ImportTsv > through bulk load ever 15 minutes. This works fine. > > In Phoe

Re: How and where can I get help to set up my "phoenix cluster" for production?

2016-10-13 Thread Ted Yu
Hortonworks does offer support. > On Oct 13, 2016, at 5:40 AM, Antonio Murgia wrote: > > As far as I know, cloudera let's you install Phoenix through a Parcel, for > free. But they do not offer support for Phoenix. > >> On 10/13/2016 01:38 PM, Cheyenne Forbes wrote: >> Thats the question I sh

Re: How and where can I get help to set up my "phoenix cluster" for production?

2016-10-13 Thread Ted Yu
If there're people who do this for free, would you trust them ? > On Oct 13, 2016, at 4:30 AM, Cheyenne Forbes > wrote: > > Are there people who do this for free?

Re: Creating secondary index on Phoenix view on Hbase table throws error

2016-10-12 Thread Ted Yu
bq. my h-base-site.xml Seems to be typo above - did you mean hbase-site.xml ? Have you checked every region server w.r.t. the value for hbase.regionserver.wal.codec ? Cheers On Wed, Oct 12, 2016 at 3:22 PM, Mich Talebzadeh wrote: > Hi, > > In the following "marketDataHbase" is a view on Hbase

Re: Accessing phoenix tables in Spark 2

2016-10-07 Thread Ted Yu
JIRA on hbase side: HBASE-16179 FYI On Fri, Oct 7, 2016 at 6:07 AM, Josh Mahonin wrote: > Hi Mich, > > There's an open ticket about this issue here: > https://issues.apache.org/jira/browse/PHOENIX- > > Long story short, Spark changed their API (again), breaking the existing > integration. I

Re: where clause on Phoenix view built on Hbase table throws error

2016-10-05 Thread Ted Yu
Please take a look at phoenix-core/src/it/java/org/apache/phoenix/end2end/ToNumberFunctionIT.java where to_number() is used. On Wed, Oct 5, 2016 at 7:34 AM, Mich Talebzadeh wrote: > Thanks John. > > 0: jdbc:phoenix:rhes564:2181> select "Date","volume" from "tsco" where > "Date" = '1-Apr-08'; > +

Re: where clause on Phoenix view built on Hbase table throws error

2016-10-05 Thread Ted Yu
I think phoenix mailing list is the proper one for this thread. On Wed, Oct 5, 2016 at 7:24 AM, John Leach wrote: > > Remove the double quotes and try single quote. Double quotes refers to an > identifier… > > Cheers, > John Leach > > > On Oct 5, 2016, at 9:21 AM, Mich Talebzadeh > wrote: > >

Re: When would/should I use spark with phoenix?

2016-09-11 Thread Ted Yu
w.r.t. Resource Management, Spark also relies on other framework such as YARN or Mesos. Cheers On Sun, Sep 11, 2016 at 6:31 AM, John Leach wrote: > Spark has a robust execution model with the following features that are > not part of phoenix > * Scalable > * fault tolerance with

Re: Cannot select data from a system table

2016-08-31 Thread Ted Yu
rs) > and same can be used for keywords. > > bq. Looks like tokens in phoenix-core/src/main/antlr3/PhoenixSQL.g would give > us good idea. > Yes Ted, you are right . Phoenix keywords are the tokens in > phoenix-core/src/main/antlr3/PhoenixSQL.g > > > >>

Re: Help w/ table that suddenly keeps timing out

2016-08-29 Thread Ted Yu
I searched for "Cannot get all table regions" in hbase repo - no hit. Seems to be Phoenix error. Anyway, the cause could be due to the 1 offline region for this table. Can you retrieve the encoded region name and search for it in the master log ? Feel free to pastebin snippets of master / region

Re: Cannot select data from a system table

2016-08-21 Thread Ted Yu
rds documented > (even if just a list) somewhere, I've been looking at this page: > http://phoenix.apache.org/language/index.html -- it feels like where I > should find a list like that, but I don't see it explicitly called out. > > -Aaron > > On Aug 21, 2016, at 09:04, T

Re: Cannot select data from a system table

2016-08-21 Thread Ted Yu
Ankit: Is this documented somewhere ? Thanks On Sun, Aug 21, 2016 at 6:07 AM, Ankit Singhal wrote: > Aaron, > > you can escape check for reserved keyword with double quotes "" > > SELECT * FROM SYSTEM."FUNCTION" > > Regards, > Ankit Singhal > > On Fri, Aug 19, 2016 at 10:47 PM, Aaron Molitor <

Re: Table Delete in Apache Hbase

2015-06-11 Thread Ted Yu
Looks like the questions would be better answered on Phoenix mailing list. On Thu, Jun 11, 2015 at 11:47 AM, Arun Kumaran Sabtharishi < arun1...@gmail.com> wrote: > Hello Hbase users and developers, > > I have a few questions regarding how table table delete works in hbase. > > *What I know:* > I

Re: Problems with Phoenix and HBase

2015-05-18 Thread Ted Yu
Sending to Phoenix user mailing list. Here is the thread: http://search-hadoop.com/m/YGbbu2WzHtZBkq1 On Mon, May 18, 2015 at 7:20 AM, Asfare wrote: > Can someone give some tips? > > > > -- > View this message in context: > http://apache-hbase.679495.n3.nabble.com/Problems-with-Phoenix-and-HBase

Re: HBase Cluster Down: No jar path specified for org.apache.hadoop.hbase.regionserver.LocalIndexSplitter

2015-03-05 Thread Ted Yu
Ani: You can find Phoenix release artifacts here: http://archive.apache.org/dist/phoenix/ e.g. for 4.1.0: http://archive.apache.org/dist/phoenix/phoenix-4.1.0/bin/ Cheers On Thu, Mar 5, 2015 at 5:26 PM, anil gupta wrote: > @James: Could you point me to a place where i can find tar file of > Ph