Thanks for the answer, but it is not the solution. See my reply above. ... View more

1. I can't open Hive WebUI. It can't connect to the Hive website. It shows "ERR_CONNECTION_REFUSED". 2. No, it always can't connect to the website. 3. There is no other message about it.  4. I have used command line, "hadoop version". There is no information about CDH version. All codes are below. https://github.com/KarenPHS/HadoopCluster ... View more

Will formatting zkfc and restarting namenode work as this issue is basically due to communication failure between HealthcheckRPC of zkfc and local namenode. ... View more

Can you do check 4200 port is listening or not.. Below is similar cloudera community post for your reference: https://community.cloudera.com/t5/Support-Questions/Unable-to-connect-to-port-4200-WebSSH-using-HDP-2-5/td-p/133615 ... View more

You need a UDF to parse the XML string and extract the values. As far as I know, Impala doesn't have a native function to do it. ... View more

Thanks for your update. I have 10 hive tables and I am inserting data from these 10 tables to one hive denorm table but we have some conditions for few columns. Here every column is coming from some table and I need to put populate the column only if certain condition is true for example if table has name,age,salary column and condition is like if salary is 1000 then populate name column. INSERT INTO TABLE MANAGE(NAME,country)SELECT TABLENAME.NAME,TABLENAME.COUNTRY FROM TABLE1,TABLE2 How can I populate the name column with some condition. ... View more

Hi,   What is the query you are using to read the data from table? can you attach its "query profile" and coordinator logs to have a look?   Regards, Chethan YM ... View more

That's what I was afraid of.  I'm going through Cloudera Manager and looking at queries where missing_stats=true and going through one by one more or less.  Thanks for the response! ... View more

Hi, I have tested the same in my lab cluster, seems to be multi character delimiters will not works in impala.   Below is my testing when i tried with ',|'   Failing: Query: Create table test ( name string, place string ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',|' STORED AS TEXTFILE TBLPROPERTIES('serialization.null.format'='') ERROR: AnalysisException: ESCAPED BY values and LINE/FIELD terminators must be specified as a single character or as a decimal value in the range [-128:127]: ,|   Created: [host-1abc.cloudera.com:21000] default> Create table test ( name string, place string ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'                                                   > STORED AS TEXTFILE                                                   > TBLPROPERTIES('serialization.null.format'=''); Query: Create table test ( name string, place string ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' STORED AS TEXTFILE TBLPROPERTIES('serialization.null.format'='') +-------------------------+ | summary                 | +-------------------------+ | Table has been created. | +-------------------------+   Created: [host-1abc.cloudera.com:21000] default> Create table test1 ( name string, place string ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','                                                   > STORED AS TEXTFILE                                                   > TBLPROPERTIES('serialization.null.format'=''); Query: Create table test1 ( name string, place string ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE TBLPROPERTIES('serialization.null.format'='') +-------------------------+ | summary                 | +-------------------------+ | Table has been created. | +-------------------------+ ... View more