Hi @vjain ,   To configure the BuckeCache in the descripption there is a two JVM properties. Which one to use please?  : HBASE_OPTS  or HBASE_REGIONSERVER_OPTS    In the  hbase-env.sh  file for each RegionServer, or in the  hbase-env.sh  file supplied to Ambari, set the  -XX:MaxDirectMemorySize  argument for HBASE_REGIONSERVER_OPTS  to the amount of direct memory you wish to allocate to HBase. In the configuration for the example discussed above, the value would be  241664m . ( -XX:MaxDirectMemorySize  accepts a number followed by a unit indicator;  m  indicates megabytes.) HBASE_OPTS="$HBASE_OPTS -XX:MaxDirectMemorySize=241664m"   Thanks, Helmi KHALIFA ... View more

Hi,   I am facing the same problem. Do you find a solution to your problem ?   Best, Helmi Khalifa ... View more

Hi @Rak ;   here the script : CREATE EXTERNAL TABLE IF NOT EXISTS sample_date (sc_code string, ddate timestamp, co_code DECIMAL, high DECIMAL, low DECIMAL, open DECIMAL, close DECIMAL, volume DECIMAL, no_trades DECIMAL, net_turnov DECIMAL, dmcap DECIMAL, return DECIMAL, factor DECIMAL, ttmpe DECIMAL, yepe DECIMAL, flag string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ' LINES TERMINATED BY '\n' STORED AS TEXTFILE LOCATION '/lab/itim/ccbd/helmi/sampleDate' tblproperties('skip.header.line.count'='1'); ALTER TABLE sample_date SET SERDEPROPERTIES ("timestamp.formats"="MM/DD/YYYY");   Could you accept the answer please ?   Best, Helmi KHALIFA ... View more

Hi @Ra    You have to change the name and column type as youscan see in red below : sc_code string ddate date co_code double high double low double open double close double volume double no_trades double net_turnov double dmcap double return double factor double ttmpe double yepe double flag string   I tried it and it works well for me.   Best, Helmi KHALIFA ... View more

Hi @Rak ,   Can you show us some sample the 5 first rows of your csv file, please ?   Best, Helmi KHALIFA ... View more

Hi @saivenkatg55    More details please? screenshots of Yarn UI ?   Best, Helmi KHALIFA ... View more

Hi @RNN    The best solution is to convert the Monthes to integers like:   -Oct- => -10- -Dec- =>-12-   So that is what i tested as you can see my file below: $ hdfs dfs -cat /lab/helmi/test_timestamp_MM.txt 1,2019-10-14 20:00:01.027898 2,2019-12-10 21:00:01.023 3,2019-11-25 20:00:01.03 4,2019-01-06 20:00:01.123   Create a Hive table : hive> CREATE EXTERNAL TABLE ttime(id int, t string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE LOCATION '/lab/helmi/';   hive> select * from ttime; OK 1 2019-10-14 20:00:01.027898 2 2019-12-10 21:00:01.023 3 2019-11-25 20:00:01.03 4 2019-01-06 20:00:01.123 Time taken: 0.566 seconds, Fetched: 4 row(s)   Finally i created another table with the right format: hive> create table mytime as select id, from_utc_timestamp(date_format(t,'yyyy-MM-dd HH:mm:ss.SSSSSS'),'UTC') as datetime from ttime;       Best, Helmi KHALIFA           ... View more

Could you try on another table? Looks like you have an encoding problem with these caracteres.   Best, Helmi KHALIFA ... View more

I just tried it and it works for me as you can see in the print screen  below:   Are you sure that the table is not empty ?   Best, Helmi  ... View more

I am not sure that you cant use it as your verison of hbase is   2.1.0 > 2.0.3 right?   could you try it and share the result of RIT ?   Best, Helmi  ... View more

Hi @Algrach ,   Could you try this and tell me if it works ?   create view if not exists tdv.test_rus as select * from tdv.test_t_rus where c1 = '<the value>';   Best, Helmi KHALIFA   ... View more

Hi @sachith ,   Use QueryRecord processor and configure/enable Reader/Writer controller services Add custom sql query as new property to the processor   QueryRecord configs: select id,age,     CASE WHEN name='' THEN 'abc'     end name from FLowfile   The output flowfile from QueryRecord processor will have your desired result id,name,age 1,sachith,29 2,abc,17   Best, Helmi KHALIFA ... View more

Hi @Li ;   Did you try hbck1 before ? it is deprecated and if you tried it it seems that it complicate the situation with hbase 2.x   https://github.com/apache/hbase-operator-tools/tree/master/hbase-hbck2   Best, Helmi KHALIFA ... View more

Hi Suresh,   There is no command but you can easily  find  the information on the HBase Web UI.   http://host:16010/master-status#baseStats   Best, Helmi KHALIFA   ... View more

Hi rename the file gateway.jks mv /var/lib/knox/data-2.6.4.0-91/security/keystores/gateway.jks /var/lib/knox/data-2.6.4.0-91/security/keystores/gateway.jks.bck when you start the know instance it will create a new certificate. Best, Helmi KHALIFA ... View more

Hi rename the file gateway.jks mv /var/lib/knox/data-2.6.4.0-91/security/keystores/gateway.jks /var/lib/knox/data-2.6.4.0-91/security/keystores/gateway.jks.bck when you start the know instance it will create a new certificate. Best, Helmi KHALIFA ... View more

Hi Sanket, Did you solve this problem? I am encountring the same problem.. many Major compaction the same day in the same Column Family and the same server? Thanke Helmi KHALIFA ... View more

Hi Geoffrey, Thank you for your answer. I checked the pdf but there are manu differences between yours and mine as it is hdp 2.6.5 Vs hdp 3.1.0.0-78 Thanks, Helmi ... View more

hi Muji, Great job 🙂 just missing a ',' after : B_df("_c1").cast(StringType).as("S_STORE_ID") // Assign column names to the Region dataframe val storeDF = B_df.select( B_df("_c0").cast(IntegerType).as("S_STORE_SK"), B_df("_c1").cast(StringType).as("S_STORE_ID"), B_df("_c5").cast(StringType).as("S_STORE_NAME") ) ... View more

Hi Neeraj, Allowing read and wright to all users to Poenix SYSTEM tables is not really secure. Is there any solution to avoid it? Thanks Helmi ... View more