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

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

Hi,   Can you provide these below details to understand the issue:   1. Initially from where you created the table in hive or impala? 2. Provide the DDL of the table that you are trying to query from impala.      # show create table <table-name>; 3. list the files from hdfs path ( you will see the table path in the DDL def. )     # hdfs dfs -ls /table/path/ 4. Are you able to access the same table data from hive?( if you are facing the issues from impala?  vice versa) 5. Go to HS2 logs/coordinator logs copy the entire error stack trace for the query that is failing and paste here.   I think these are the basic details needed for analysing the issue.   Regards, Chethan YM ... View more

Hi,   Please do attach the screenshot of the error and let us know what exactly you are trying to achieve and where you are facing the issue.   Regards, Chethan YM ... View more

Hi,   Can you try the query something like below to insert the data from multiple tables?   insert into DemoTable1945(StudentName,StudentAge) select tbl1.Name,tbl2.Age from DemoTable1943 tbl1,DemoTable1944 tbl2;   Let us know if this helps.   Regards, Chethan YM ... 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

Hello, Have you tried with a query like this ->  select <column-name> from <table-name>; If this is not your expectation let us know in detail regarding the requirement.   Regards, Chethan YM ... View more

Hi @wbaihp ,   1. Is this issue with all the queries or any few queries? 2. Please attach the query profile and its coordinator logs to have a look.   ... View more