SQL with join are running slow

Hi, We have observed the SQL statements with table inner join are running very slow. >From the explain plan we have noticed the first table filtered data is sent to client and the subsequent table joins are run from client each joined table data. Is it the way Phoenix execute SQL join statements?

Re: Problem starting region server with Hbase version hbase-2.0.0

yes correct I am using Hbase on hdfs with hadoop-2.7.3 The file system is ext4. I was hoping that I can avoid the sync option, many thanks Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

Re: Problem starting region server with Hbase version hbase-2.0.0

On Wed, Jun 6, 2018 at 6:11 PM, Mich Talebzadeh wrote: > > > so the region server started OK but then I had a problem with master :( > > java.lang.IllegalStateException: The procedure WAL relies on the ability to > hsync for proper operation during component failures, but the underlying > filesyst

Re: Problem starting region server with Hbase version hbase-2.0.0

Thanks all. in my older version of Hbase 1.2.3 I had added the correct phoenix jar file (phoenix-4.8.1-HBase-1.2-client.jar) to /lib directory of Hbase. I found the correct jar file for Hbase 2.0.0 in phoenix-5.0.0-alpha-HBase-2.0-client.jar jar tvf phoenix-5.0.0-alpha-HBase-2.0-client.jar|grep

Re: Problem starting region server with Hbase version hbase-2.0.0

Thanks Sean. I downloaded Phoenix for Hbase version 2 (apache-phoenix-5.0.0-alpha-HBase-2.0-bin) but still the same error 2018-06-06 21:45:15,297 INFO [regionserver/rhes75:16020] wal.AbstractFSWAL: WAL configuration: blocksize=256 MB, rollsize=128 MB, prefix=rhes75%2C16020%2C1528317910703, suffix

FINAL REMINDER: Apache EU Roadshow 2018 in Berlin next week!

Hello Apache Supporters and Enthusiasts This is a final reminder that our Apache EU Roadshow will be held in Berlin next week on 13th and 14th June 2018. We will have 28 different sessions running over 2 days that cover some great topics. So if you are interested in Microservices, Internet of