Re: phoenix do not show my tables

Thanks, Tongzhou. They have not Phoenix schama. I don't map the HBase tables into Phoenix. 2016-06-28 13:27 GMT+08:00 Simon Wang : > Do you mean your HBase tables? They don’t have Phoenix schema. Try map a > HBase table into Phoenix. >

Re: phoenix do not show my tables

Do you mean your HBase tables? They don’t have Phoenix schema. Try map a HBase table into Phoenix.  -Tongzhou > On Jun 27, 2016, at 10:18 PM, 易剑 wrote: > > Why do not phoenix show my

phoenix do not show my tables

Why do not phoenix show my tables except SYSTEM TABLES. 0: jdbc:phoenix:hadoop-001:2181> !tables ++--+-+---+--+-+ | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | TYPE_NA |

Re: Re: how to avoid full scan

Thank you James ! I filed a new JIRA https://issues.apache.org/jira/browse/PHOENIX-3033. jinzh...@wacai.com From: James Taylor Date: 2016-06-28 13:04 To: user Subject: Re: how to avoid full scan Hi, One way to forbid a full table scan, is to have your own client which compiles the query

Re: how to avoid full scan

Hi, One way to forbid a full table scan, is to have your own client which compiles the query first (you'd need to dip down under JDBC -- see QueryComilerTest.getQueryPlan() for an example) to get the QueryPlan. You can then easily detect if it's a full table scan looking at the ScanRanges from

how to avoid full scan

hi, Our hbase cluster is often over load because of a careless phoenix full scan. Is there anything I can do to void this? I want to forbid full scan on specified table. How to do it? jinzh...@wacai.com

Re: Spark 1.6 (CDH 5.7) and Phoenix 4.7 (CLABS)

Hi Sean, I figured out the problem. By putting these jars in the Spark classpath.txt file located in Spark conf, this allowed for these to be loaded first. This fixed it! Thanks, Ben > On Jun 27, 2016, at 4:20 PM, Sean Busbey wrote: > > Hi Ben! > > For problems with the

Re: Spark 1.6 (CDH 5.7) and Phoenix 4.7 (CLABS)

Hi Ben! For problems with the Cloudera Labs packaging of Apache Phoenix, you should first seek help on the vendor-specific community forums, to ensure the issue isn't specific to the vendor: http://community.cloudera.com/t5/Cloudera-Labs/bd-p/ClouderaLabs -busbey On 2016-06-27 15:27 (-0500),

Re: Avatica/Phoenix-Query-Server .NET driver

I haven't used this driver (don't write any .NET code), but I used it as a reference while building (https://github.com/Boostport/avatica), in particular, setting up the HTTP requests correctly. Francis On 28/06/2016 8:19 AM, Josh Elser wrote: Hi, I was just made aware of a neat little .NET

Avatica/Phoenix-Query-Server .NET driver

Hi, I was just made aware of a neat little .NET driver for Avatica (specifically, the authors were focused on Phoenix's use of Avatica in the Phoenix Query Server). https://www.nuget.org/packages/Microsoft.Phoenix.Client/1.0.0-preview I'll have to try it out at some point, but would love to

Spark 1.6 (CDH 5.7) and Phoenix 4.7 (CLABS)

Anyone tried to save a DataFrame to a HBase table using Phoenix? I am able to load and read, but I can’t save. >> spark-shell —jars >>

Re: Bulk loading and index

Tongzhou, Please file a JIRA for supporting ALTER INDEX REBUILD ASYNC. This would be a good addition and not very difficult to implement. Contributions are, of course, always welcome. Regards, James On Sun, Jun 26, 2016 at 2:45 AM, Ankit Singhal wrote: > HI