Impala concatenate string

Question

Hi. Is there a way to concatenate two strings using Impala query? I have to strings "cluster id" and "cluster name". How to concatenate them?

Answer 1

Yes, you can concatenate two strings using Impala. Refer to the below query:

select concat('cluster id' , 'cluster name');
+---------------------------------------+
| concat('cluster id ', 'cluster name') |
+---------------------------------------+
| cluster id cluster name               |
+---------------------------------------+

Comments

strings yes it will do. But I cannot concat two columns of same data types. Its returning null.

select concat(cola,colb) from tab; --> Null

Pls educate

---

Hi@Gautham,

It should return your output. Check your data type once. If possible share your dataset and command as well.