I'm trying to create a new table using the substring function in hive. Is this the correct way?:

create table substring_income_dataset
select year, substring(income_total, 1, 2), benefit_type,
from income_dataset;

I'm trying to create a new table using the substring function in hive. Is this the correct way?:

create table substring_income_dataset
select year, substring(income_total, 1, 2), benefit_type,
from income_dataset;

• sql
• hive

1 Answer 1

It looks like you are trying to get data from table income_dataset into your new table substring_income_dataset, so do the following instead:

CREATE TABLE substring_income_dataset 
AS 
    SELECT year, substring(income_total, 1, 2), benefit_type 
    FROM income_dataset;