split string that includes semicolons in Hive

Question

how can I achieve splitting a string field delimited by semicolons in hive?

select split(f1,";")[0] from table;

Answer 1

You can write this way select split(f1,'\073')[0] from table;

Answer 2

Wanted to re-iterate that this is indeed a Hue bug, but only in the Hortonworks version. The latest Cloudera version of the Hue runs this fine.

Answer 3

The below command will work:

input table

 1;Neethu KV
  2;Ram KV

query 1:

select split(name,"\\;")[0],school from table_test, where name refers to your column name to be split.

output

1 KV
2 KV

Query 2 :

select split(name,"\\;")[1],school from table_test, where name refers to your column name to be split.

output

Neethu KV
Ram KV