I believe it was just intended as an example with your own data. For an example that uses data available on every linux machine, you can do:
create table passwd ( name string, not_used string, uid int, gid int, full_name string, home_dir string, shell string ) row format delimited fields terminated by ":" stored as textfile; load data local inpath "/etc/passwd" overwrite into table passwd; Note that makes a table out of your local user database, so make sure that it is a virtual machine or has security turned on. .. Owen On Mon, Feb 7, 2022 at 7:36 AM <akhed...@talentumglobal.com> wrote: > Hi, > > The original Hive tutorial available online refers to a dataset called > "pv_2008-06-08.txt": > > https://cwiki.apache.org/confluence/display/Hive/Tutorial > > And of course, it is referenced in dozens of tutorials all over the > Internet. However, there is no way I can find the original data anywhere. > Does anybody have a clue where is it? > > > > > > Thanks And Regards > > Amit > > (Amit S Khedkar) > > M - 9422321048 > > >
