Separate DDD from phone with HIVEQL

Asked

Viewed 15 times

-1

I have a table with fields DDD and Phone. Some were registered correctly, others the ddd is next to the phone and need to separate.

CURRENT TABLE:

inserir a descrição da imagem aqui

UPDATED TABLE:

inserir a descrição da imagem aqui

I am starting my studies in HIVEQL, how can I make this change?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.