Load dat file in into hive table

hive
#1

Hi,

Could any one would help me reading .dat file into hive table urgently
table format
Create table results (
userid string,
unix_time bigint,
results map<int,struct<advertisers:map<string,array<structeurocents:int,breakfast:boolean>>>>)

sample data (.dat file)

Žè4853215f-6f5d-4d7e-a934-a918d600ada114945156189089Amoma8334falsea11792falseexpedia33072falseMercure24665false8001Amoma35653falseexpedia30914falseMercure34821falseTui.com27294falsebooking.com12814false8002Amoma5648falsea33905falseDestinia18043falsea18026falsebooking.com28711false9090expedia29201falseTui.com7334false9091Amoma28486falsea13290falseexpedia30273falseMercure17221false9092Amoma15561falseMercure26709falseTui.com5109falsebooking.com7738falsea22141false7045expedia8325falseMercure20957falseDestinia4980falsea24166falseTui.com4234false7046Amoma12181falsea21322falseDestinia4412falseTui.com21449falsea39362false7047expedia31385falseTui.com23343falsebooking.com19200falsea27702falsea21423false6032booking.com31111falsea14353false6033expedia25866false6035expedia20520falseAmoma4141falsea4999falseDestinia36507false6036Destinia21634falsea14913falsea24434false

Quick suggestions would be appreciated.

Thanks,
Ashok.Sagar

0 Likes

#2

@Ashok_Sagar I hope this will help you.

0 Likes