Hello, I create a phoenix view on an existing Hbase table wher all hte col family name are lowercas. the to be able to query it I have to put all the time " before and after every column name. It's a little bit annoysing, do you have a workaroung? 🙂 Thanks, Michel ... View more

Hello, I have a phoenix view on an existing hbase table. I don't find in the documentation how to select every lines of a table where the column "name" match with a specific regex or function on string like contain, start with, etc. For example in "traditional sql": select name,phone from table1 where like "%ab%; or every ligne with a rowkey that start with "blabla". Thanks in advance to point me how to do it easily (I hope that's not needed to use UDF...) Michel ... View more

Hi, I have Hive running over HBase table. Is it interesting in this case to analyze the table for the CBO? Or is it only interesting whe nyou have hive with orc file? Thanks in advance, Michel ... View more

Hello, I have "stupid" question of a beginner in SparkSQL. 🙂 Just to correctly understand how it works: If I have a HBase table with 28Tera of data (90Billions of lines) and only a few tera of memory in the cluster, what's going to happen? The dataframe will be bigger that the available memory, so is it going to swap? It will crash? I would like to clearly understand the mecanisme that spark used to manage that. Also do you have any recommendation in term of infrastructure to handle this kind of database? Thanks in advance for all the info 🙂 Michel ... View more

Hi, I would like additional information about encryption in HBase. HBase is working over HDFS and HDFS support encryption so when the data is store, they are encrypted, right? I would like also the encrypt the content into a cell. So encryption into the cell + encryption of the HFile (hdfs) is those features available? Can you point me nice documentation, examples on how to encrypt data into the cell? I would like also to change the key encryption every hours, any idea how to manage that in a "easy" way? 🙂 Thanks in advance, Michel ... View more