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 anilgupt...@gmail.com wrote: @James: Could you point me to a place where i can

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 aman...@hotmail.com wrote: Can someone give some tips? -- View this message in context:

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

2017-02-20 Thread Ted Yu
ays, just ignore it. > > > On Feb 20, 2017 09:47, "Ted Yu" <yuzhih...@gmail.com> wrote: > > I received such message as well. > > You can ignore it. > > On Feb 20, 2017, at 5:46 AM, Cheyenne Forbes < > cheyenne.osanu.for...@gmail.com> wrote: >

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

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

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

Re: Cannot select data from a system table

2016-08-21 Thread Ted Yu
Ted's question... Are the reserved words 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 Au

Re: Cannot select data from a system table

2016-08-31 Thread Ted Yu
gt; > > >> On Sun, Aug 21, 2016 at 8:33 PM, Ted Yu <yuzhih...@gmail.com> wrote: >> Looks like tokens in phoenix-core/src/main/antlr3/PhoenixSQL.g would give us >> good idea. >> >> Experts please correct me if I am wrong. >> >>> On Sun

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,

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"

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

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: 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.

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

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: 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: >>

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

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, > >

Re: Specify maven dependency

2017-06-29 Thread Ted Yu
Best, > -- > Juvenn 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: Juven

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,

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

2017-07-06 Thread Ted Yu
ailed sync-before-close but no 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.logRo

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

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

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

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

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 >