×
INFO  : Compiling command(queryId=hive_20240327071554_8c38e364-65a8-4f9a-aac6-5948e1c73bfe): -- Drop for retesting purposes
DROP TABLE student.releasedates
INFO  : Semantic Analysis Completed
INFO  : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
INFO  : Completed compiling command(queryId=hive_20240327071554_8c38e364-65a8-4f9a-aac6-5948e1c73bfe); Time taken: 0.004 seconds
INFO  : Concurrency mode is disabled, not creating a lock manager
INFO  : Executing command(queryId=hive_20240327071554_8c38e364-65a8-4f9a-aac6-5948e1c73bfe): -- Drop for retesting purposes
DROP TABLE student.releasedates
INFO  : Starting task [Stage-0:DDL] in serial mode
INFO  : Completed executing command(queryId=hive_20240327071554_8c38e364-65a8-4f9a-aac6-5948e1c73bfe); Time taken: 0.023 seconds
INFO  : OK
 Success.

My Snippet

-- Current netflix2023 table wasn't uploaded properly and has all null values for `Release Date`
-- Create table with release dates that contains title and releasedate
CREATE TABLE student.releasedates (
title STRING,
releasedate STRING
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE
LOCATION '/user/student/netflix'
;
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
    ×
    INFO  : Compiling command(queryId=hive_20240327071559_75841a8c-52eb-4221-8bd5-349a6e79d10e): -- Current netflix2023 table wasn't uploaded properly and has all null values for `Release Date`
    -- Create table with release dates that contains title and releasedate
    CREATE TABLE student.releasedates (
        title STRING,
        releasedate STRING
    )
    ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ','
    STORED AS TEXTFILE
    LOCATION '/user/student/netflix'
    INFO  : Semantic Analysis Completed
    INFO  : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
    INFO  : Completed compiling command(queryId=hive_20240327071559_75841a8c-52eb-4221-8bd5-349a6e79d10e); Time taken: 0.002 seconds
    INFO  : Concurrency mode is disabled, not creating a lock manager
    INFO  : Executing command(queryId=hive_20240327071559_75841a8c-52eb-4221-8bd5-349a6e79d10e): -- Current netflix2023 table wasn't uploaded properly and has all null values for `Release Date`
    -- Create table with release dates that contains title and releasedate
    CREATE TABLE student.releasedates (
        title STRING,
        releasedate STRING
    )
    ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ','
    STORED AS TEXTFILE
    LOCATION '/user/student/netflix'
    INFO  : Starting task [Stage-0:DDL] in serial mode
    INFO  : Completed executing command(queryId=hive_20240327071559_75841a8c-52eb-4221-8bd5-349a6e79d10e); Time taken: 0.023 seconds
    INFO  : OK
     Success.

    My Snippet

    -- Check CSV was uploaded properly and values exist in table
    SELECT * FROM student.releasedates LIMIT 5;
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
      ×
      INFO  : Compiling command(queryId=hive_20240327071650_6f1bcd71-2da4-41eb-bf48-ebef7629d1a9): -- Check CSV was uploaded properly and values exist in table
      SELECT * FROM student.releasedates LIMIT 5
      INFO  : Semantic Analysis Completed
      INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:releasedates.title, type:string, comment:null), FieldSchema(name:releasedates.releasedate, type:string, comment:null)], properties:null)
      INFO  : Completed compiling command(queryId=hive_20240327071650_6f1bcd71-2da4-41eb-bf48-ebef7629d1a9); Time taken: 0.046 seconds
      INFO  : Concurrency mode is disabled, not creating a lock manager
      INFO  : Executing command(queryId=hive_20240327071650_6f1bcd71-2da4-41eb-bf48-ebef7629d1a9): -- Check CSV was uploaded properly and values exist in table
      SELECT * FROM student.releasedates LIMIT 5
      INFO  : Completed executing command(queryId=hive_20240327071650_6f1bcd71-2da4-41eb-bf48-ebef7629d1a9); Time taken: 0.001 seconds
      INFO  : OK
        releasedates.title releasedates.releasedate
        releasedates.title releasedates.releasedate
      1The Night Agent: Season 12023-03-23
      2Ginny & Georgia: Season 22023-01-05
      3The Glory: Season 1 // 더 글로리: 시즌 12022-12-30
      4Wednesday: Season 12022-11-23
      5Queen Charlotte: A Bridgerton Story2023-05-04

      My Snippet

      -- Drop for retesting purposes
      DROP VIEW student.corrected_netflix2023;
      XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
        ×
        INFO  : Compiling command(queryId=hive_20240327071657_be4af6d9-1174-4299-a0c6-4124723ad504): -- Drop for retesting purposes
        DROP VIEW student.corrected_netflix2023
        INFO  : Semantic Analysis Completed
        INFO  : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
        INFO  : Completed compiling command(queryId=hive_20240327071657_be4af6d9-1174-4299-a0c6-4124723ad504); Time taken: 0.004 seconds
        INFO  : Concurrency mode is disabled, not creating a lock manager
        INFO  : Executing command(queryId=hive_20240327071657_be4af6d9-1174-4299-a0c6-4124723ad504): -- Drop for retesting purposes
        DROP VIEW student.corrected_netflix2023
        INFO  : Starting task [Stage-0:DDL] in serial mode
        INFO  : Completed executing command(queryId=hive_20240327071657_be4af6d9-1174-4299-a0c6-4124723ad504); Time taken: 0.013 seconds
        INFO  : OK
         Success.

        My Snippet

        -- Create view containing all netflix2023 values and releasedates from
        -- releasedates table earlier, joined on the first English part of the title
        -- as joining on full text narrows matching rows due to text upload issues
        CREATE VIEW student.corrected_netflix2023 AS
        SELECT
        n.title,
        n.availableglobally,
        t.releasedate,
        n.hoursviewed,
        n.numberofratings,
        n.rating,
        n.genre,
        n.keywords,
        n.description
        FROM
        default.netflix2023 n
        LEFT OUTER JOIN
        student.releasedates t
        ON
        split(n.title, '//')[0] = split(t.title, '//')[0];
        XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
          ×
          INFO  : Compiling command(queryId=hive_20240327071702_d95f0a40-55f5-44fb-a486-910fb2d6d522): -- Create view containing all netflix2023 values and releasedates from
          -- releasedates table earlier, joined on the first English part of the title
          -- as joining on full text narrows matching rows due to text upload issues
          CREATE VIEW student.corrected_netflix2023 AS
          SELECT 
              n.title,
              n.availableglobally,
              t.releasedate,
              n.hoursviewed,
              n.numberofratings,
              n.rating,
              n.genre,
              n.keywords,
              n.description
          FROM 
              default.netflix2023 n
          LEFT OUTER JOIN 
              student.releasedates t 
          ON 
              split(n.title, '//')[0] = split(t.title, '//')[0]
          INFO  : Semantic Analysis Completed
          INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:title, type:string, comment:null), FieldSchema(name:availableglobally, type:string, comment:null), FieldSchema(name:releasedate, type:string, comment:null), FieldSchema(name:hoursviewed, type:bigint, comment:null), FieldSchema(name:numberofratings, type:bigint, comment:null), FieldSchema(name:rating, type:double, comment:null), FieldSchema(name:genre, type:string, comment:null), FieldSchema(name:keywords, type:string, comment:null), FieldSchema(name:description, type:string, comment:null)], properties:null)
          INFO  : Completed compiling command(queryId=hive_20240327071702_d95f0a40-55f5-44fb-a486-910fb2d6d522); Time taken: 0.036 seconds
          INFO  : Concurrency mode is disabled, not creating a lock manager
          INFO  : Executing command(queryId=hive_20240327071702_d95f0a40-55f5-44fb-a486-910fb2d6d522): -- Create view containing all netflix2023 values and releasedates from
          -- releasedates table earlier, joined on the first English part of the title
          -- as joining on full text narrows matching rows due to text upload issues
          CREATE VIEW student.corrected_netflix2023 AS
          SELECT 
              n.title,
              n.availableglobally,
              t.releasedate,
              n.hoursviewed,
              n.numberofratings,
              n.rating,
              n.genre,
              n.keywords,
              n.description
          FROM 
              default.netflix2023 n
          LEFT OUTER JOIN 
              student.releasedates t 
          ON 
              split(n.title, '//')[0] = split(t.title, '//')[0]
          INFO  : Starting task [Stage-1:DDL] in serial mode
          INFO  : Completed executing command(queryId=hive_20240327071702_d95f0a40-55f5-44fb-a486-910fb2d6d522); Time taken: 0.014 seconds
          INFO  : OK
           Success.

          My Snippet

          -- Ensure there are 18332 values
          -- Note there are 18739, but that's okay long as we matched as many dates as possible
          -- and we can filter values out later
          SELECT COUNT(*) FROM student.corrected_netflix2023
          XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
            ×
            INFO  : Compiling command(queryId=hive_20240327071708_f79e47e9-0d8f-4b5f-a100-ba78933f22f8): -- Ensure there are 18332 values
            -- Note there are 18739, but that's okay long as we matched as many dates as possible
            -- and we can filter values out later
            SELECT COUNT(*) FROM student.corrected_netflix2023
            INFO  : Semantic Analysis Completed
            INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:_c0, type:bigint, comment:null)], properties:null)
            INFO  : Completed compiling command(queryId=hive_20240327071708_f79e47e9-0d8f-4b5f-a100-ba78933f22f8); Time taken: 0.045 seconds
            INFO  : Concurrency mode is disabled, not creating a lock manager
            INFO  : Executing command(queryId=hive_20240327071708_f79e47e9-0d8f-4b5f-a100-ba78933f22f8): -- Ensure there are 18332 values
            -- Note there are 18739, but that's okay long as we matched as many dates as possible
            -- and we can filter values out later
            SELECT COUNT(*) FROM student.corrected_netflix2023
            INFO  : Query ID = hive_20240327071708_f79e47e9-0d8f-4b5f-a100-ba78933f22f8
            INFO  : Total jobs = 1
            INFO  : Launching Job 1 out of 1
            INFO  : Starting task [Stage-1:MAPRED] in serial mode
            INFO  : Session is already open
            INFO  : Dag name: -- Ensure there are 1...orrected_netflix2023(Stage-1)
            INFO  : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
            INFO  : Status: Running (Executing on YARN cluster with App id application_1634527506680_1335)
            
            INFO  : Map 1: 0/1	Map 3: 0/1	Reducer 2: 0/1	
            INFO  : Map 1: 0/1	Map 3: 0(+1)/1	Reducer 2: 0/1
            INFO  : Map 1: 0(+1)/1	Map 3: 0(+1)/1	Reducer 2: 0/1	
            INFO  : Map 1: 0(+1)/1	Map 3: 1/1	Reducer 2: 0/1
            INFO  : Map 1: 1/1	Map 3: 1/1	Reducer 2: 0/1	
            INFO  : Map 1: 1/1	Map 3: 1/1	Reducer 2: 0(+1)/1	
            INFO  : Map 1: 1/1	Map 3: 1/1	Reducer 2: 1/1	
            INFO  : Completed executing command(queryId=hive_20240327071708_f79e47e9-0d8f-4b5f-a100-ba78933f22f8); Time taken: 6.297 seconds
            INFO  : OK
              _c0
              _c0
            118739

            My Snippet

            -- Preview for quality control
            SELECT * FROM student.corrected_netflix2023
            XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
              ×
              INFO  : Compiling command(queryId=hive_20240327071719_feea5644-d6f3-4361-9434-b8f9136aac20): -- Preview for quality control
              SELECT * FROM student.corrected_netflix2023
              INFO  : Semantic Analysis Completed
              INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:corrected_netflix2023.title, type:string, comment:null), FieldSchema(name:corrected_netflix2023.availableglobally, type:string, comment:null), FieldSchema(name:corrected_netflix2023.releasedate, type:string, comment:null), FieldSchema(name:corrected_netflix2023.hoursviewed, type:bigint, comment:null), FieldSchema(name:corrected_netflix2023.numberofratings, type:bigint, comment:null), FieldSchema(name:corrected_netflix2023.rating, type:double, comment:null), FieldSchema(name:corrected_netflix2023.genre, type:string, comment:null), FieldSchema(name:corrected_netflix2023.keywords, type:string, comment:null), FieldSchema(name:corrected_netflix2023.description, type:string, comment:null)], properties:null)
              INFO  : Completed compiling command(queryId=hive_20240327071719_feea5644-d6f3-4361-9434-b8f9136aac20); Time taken: 0.038 seconds
              INFO  : Concurrency mode is disabled, not creating a lock manager
              INFO  : Executing command(queryId=hive_20240327071719_feea5644-d6f3-4361-9434-b8f9136aac20): -- Preview for quality control
              SELECT * FROM student.corrected_netflix2023
              INFO  : Query ID = hive_20240327071719_feea5644-d6f3-4361-9434-b8f9136aac20
              INFO  : Total jobs = 1
              INFO  : Launching Job 1 out of 1
              INFO  : Starting task [Stage-1:MAPRED] in serial mode
              INFO  : Session is already open
              INFO  : Dag name: -- Preview for qualit...orrected_netflix2023(Stage-1)
              INFO  : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
              INFO  : Status: Running (Executing on YARN cluster with App id application_1634527506680_1335)
              
              INFO  : Map 1: 0/1	Map 2: 0(+1)/1	
              INFO  : Map 1: 0(+1)/1	Map 2: 1/1
              INFO  : Map 1: 1/1	Map 2: 1/1	
              INFO  : Completed executing command(queryId=hive_20240327071719_feea5644-d6f3-4361-9434-b8f9136aac20); Time taken: 2.5 seconds
              INFO  : OK
                corrected_netflix2023.title corrected_netflix2023.availableglobally corrected_netflix2023.releasedate corrected_netflix2023.hoursviewed corrected_netflix2023.numberofratings corrected_netflix2023.rating corrected_netflix2023.genre corrected_netflix2023.keywords corrected_netflix2023.description
                corrected_netflix2023.title corrected_netflix2023.availableglobally corrected_netflix2023.releasedate corrected_netflix2023.hoursviewed corrected_netflix2023.numberofratings corrected_netflix2023.rating corrected_netflix2023.genre corrected_netflix2023.keywords corrected_netflix2023.description
              1Queen Charlotte: A Bridgerton StoryYes2023-05-04503000000456246.6Comedy - Romancetelenovela -drug trafficking -cartel -femme fatale -kidnappingWhile fleeing from dangerous assailants - an assassin comes out of hiding to protect the daughter she left earlier in life.
              2Ginny & Georgia: Season 1Yes2021-02-24302100000441025.6Action - Thrillerclose up of eye -close up of eyes -close up of lips -close up of mouth -childAfter barely surviving his grievous wounds from his mission in Dhaka - Bangladesh - Tyler Rake is back - and his team is ready to take on their next mission.
              3The MotherYes2023-05-1224990000068.6Sportracial tension -black american -couple -love -lifeA young American woman from the Midwest is hired by a marketing firm in Paris to provide them with an American perspective on things.
              4The Diplomat: Season 1Yes2023-04-20214100000608535.5Comedy - Romancefriend -best friend -volunteer -teenager -sonVillain's kidnap a man's daughter in order to get hold of forgery plates which they believe to be in his possession.
              5Luther: The Fallen SunYes2023-03-102097000003007.3Romancefemale protagonist -character name in series title -american in france -location in series title -marketingFinding a ghost named Ernest haunting their new home turns Kevin's family into overnight social media sensations. But when Kevin and Ernest investigate the mystery of Ernest's past - they become a target of the CIA.
              6Fake Profile: Season 1 // Perfil falso: Temporada 1No2023-05-3120650000081658.7Drama - Horror - Thrilleralice character -caterpillar character -the mad hatter character -march hare character -dormouse characterA world -weary detective is hired to investigate the murder of a West Point cadet. Stymied by the cadets' code of silence - he enlists one of their own to help unravel the case  - a young man the world would come to know as Edgar All...
              7XO - Kitty: Season 1YesNULL200700000496.8Comedyrapping animal -rapping penguin -talking animal -talking penguin -sequelShocking tragedies shatter a tight -knit South Carolina community and expose the horrifying secrets of its most powerful family.
              8Outer Banks: Season 1Yes2020-04-151840000001192466.2Adventure - Family - Fantasybritish noir -b movie -forgery plates -kidnapping a girl -rape and sexual intercourse innuendoThe last of a two -part film centered on the life and career of John Reed - the revolutionary communist journalist.
              9Sweet Tooth: Season 2Yes2023-04-27182300000744037.5Action - Crime - Dramaghost -house -chase -car chase -based on short storyTeresa Mendoza returns to Mexico after 8 years to fight with Mexican drug dealers.
              10Perfect Match: Season 1Yes2023-02-141768000003446Adventure - Comedy - Familymurder -year 1830 -1830s -19th century -winterHiding a mysterious past - a mother lives like a nameless fugitive with her daughter as they make hotels their home and see everyone else as a threat.
              11The Marked Heart: Season 2 // Pálpito: Temporada 2Yes2023-04-19174300000118698.4Shortyear 2014 -malaysia airlines flight mh370 -airplane -investigation -missingThree young women join the newly formed Women's Army Corps (WACS) for varied reasons - and make contributions to the war effort.
              12Murder Mystery 2Yes2023-03-311736000004196617.1Comedy - Crime - Dramajunk man -junk -junk wagon -city dump -landfillDocuseries following the FIA Formula One World Championship across multiple seasons.
              13Pablo Escobar - el patrón del mal: Season 1YesNULL168300000279.4Shortprom -sex comedy -female masturbation -female nudity -teen sex comedyTyler Rake - a fearless black market mercenary - embarks on the most deadly extraction of his career when he's enlisted to rescue the kidnapped son of an imprisoned international crime lord.
              14Never Have I Ever: Season 4Yes2023-02-10163000000155.6Animation - Shortmagic -power -young woman -soldier -gay manThings go badly for a hack director and film crew shooting a low budget zombie movie in an abandoned WWII Japanese facility - when they are attacked by real zombies.
              15Your Place or MineYes2022-12-21161100000189.4Drama - Fantasy - Horrorparody comedy -spoofIn the wake of King Edward's death - Uhtred of Bebbanburg and his comrades adventure across a fractured kingdom in the hopes of uniting England at last.
              16Chiquititas (2013)No2022-12-221576000001205.9Crime - Dramaspaghetti western -italo western -eastern -ostern -second partSonic in a high -octane adventure where the fate of a strange new multiverse rests in his gloved hands.
              17Alchemy of Souls: Part 1 // 환혼: 파트 1Yes2022-10-191521000003827.1Documentary - Shortcontroversy -girl -laundry drying on a clothesline -african american -clotheslineA German youth eagerly enters World War I - but his enthusiasm wanes as he gets a firsthand view of the horror.
              18Outer Banks: Season 2Yes2021-06-101514000001183526.6Crime - Horror - Mysterypsychological drama -overprotective mother -cult -hotel -peer pressureAn unusual and touching bond develops when grieving Oona reaches out to a mysterious homeless man - offering him a place to stay in her garden shed.
              19Til Money Do Us Part: Season 1 // Hasta que la plata nos separe: Temporada 1No2023-04-26148600000132166.1Documentarywacs -war widow -war game -male female relationship -father daughter relationshipA single mother who is a renowned hired killer finds it difficult to achieve a balance between her personal and work life.
              20Mr. Queen // 철인왕후No2022-12-1614690000068.6Sportf1 -formula 1 -motor sports -car race -championshipAn Interpol agent successfully tracks down the world's most wanted art thief with help from a rival thief. But nothing is as it seems as a series of double -crosses ensues.
              21Manifest: Season 1No2023-06-0914670000079Short - Dramayear in title -2000s -number in titleThale (17) has just moved with her parents to a small town after her mother has a new job in the local police. After a student is killed brutally at a party Thale attends - she becomes a key witness. Was the killer an animal? A wolf?
              22PAW Patrol: Season 6No2023-03-0114010000098356.8Documentary - Crimedrug dealers -kidnapping -child kidnapping -shot in the head -bangladeshApril 1940. The eyes of the world are on Narvik - a small town in northern Norway - source of the iron ore needed for Hitler's war machinery. Through two months of fierce winter warfare - Hitler is dealt his first defeat.
              23The Good Bad Mother: Limited Series // 나쁜엄마: 리미티드 시리즈Yes2023-06-151399000007407.6Drama - Romancesingle take -zombie -film crew -television broadcast -rooftopWhen a young girl stows away on the ship of a legendary sea monster hunter - they launch an epic journey into uncharted waters  - and make history to boot.
              24The Recruit: Season 1Yes2023-02-221393000004268807Comedylawyer -19th century -legal -legal drama -legal battleAn orphaned boy enrolls in a school of wizardry - where he learns the truth about himself - his family and the terrible evil that haunts the magical world.
              25Bloodhounds: Season 1 // 사냥개들: 시즌 1Yes2020-12-251366000001113617.6Action - Adventure - Dramaanglo saxon -kingdom -exploration -warrior -epicBased on the true story of a father and son who repair their fractured relationship during a forced hike of the Appalachian trail to find their beloved lost dog.
              26Glass Onion: A Knives Out MysteryYes2020-05-311362000001556.4Documentaryfast -based on video game -sonic the hedgehog -anthropomorphic animal -sonic the hedgehog characterCharlie Brandis leads a quiet and uneventful life as a wallflower. His parents trust him - his friends like him - girls are indifferent toward him. Then there's the girl he's watched from afar - Annie Briggs - who doesn't even know he...
              27Black Mirror: Season 6Yes2023-01-271348000001024.9Horrorlawyer -spin off -psychosomatic illness -criminal lawyer -drug tradeIt follows the rise and fall of the American financier and ponzi schemer: Madoff.
              28Triptych: Season 1 // Tríada: Temporada 1Yes2022-05-271336000001746.4Drama - Western1910s -anti war -shell shock -ptsd post traumatic stress disorder -depressionShort documentary about making the second season of The Witcher (2019).
              29Bridgerton: Season 1Yes2022-03-25133400000145919.2Drama - Horror -  SciFititle co written by female -title co directed by female -f ratedCharlie Brandis leads a quiet and uneventful life as a wallflower. His parents trust him - his friends like him - girls are indifferent toward him. Then there's the girl he's watched from afar - Annie Briggs - who doesn't even know he...
              30The Marked Heart: Season 1 // Pálpito: Temporada 1Yes2023-01-06120500000483708.5Documentary - Sportnon fictionMarion and Jack try to rekindle their relationship with a visit to Paris - home of Marion's parents  - - and several of her ex -boyfriends.
              31Little Angel: Volume 1Yes2023-04-281200000001631916Action - Comedy - Crimehomosexual -gay serial killer -murder -serial killer -homosexualityIn celebration of Season 2 being released soon - the Glitch Productions team put all of Season 1 into a single movie to watch in one go.
              32PAW Patrol: Season 5No2023-03-081189000002511.6Short - Comedynorwegian army -nazi invasion of norway -winter -year 1940 -man in uniformThree young women looking for adventure get jobs on a dude ranch.
              33Sex/Life: Season 1Yes2023-05-1911580000070577.4Biography - Crime - Dramacgi animation -bounty hunter -alien -danger -laser gunThe trials and tribulations of criminal lawyer Jimmy McGill in the years leading up to his fateful run -in with Walter White and Jesse Pinkman.
              34We Have a GhostYes2023-01-27113600000331796.9Action - Drama - Historydog -search -find -journey -fatherAn executive goes through an unexpected breakup - then accepting an assignment to go undercover and learn about the tourist industry in Vietnam.
              35Crash Landing on You: Season 1 // 사랑의 불시착: 시즌 1Yes2017-10-03102800000667508.1Drama - Wartv specialA lawyer defending a wealthy man begins to believe his client is guilty of more than just one crime.
              36MH370: The Plane That Disappeared: Limited SeriesYes2021-12-2910170000068865.5Action - Adventure - Dramaparty -teenager -sex comedyFollows the tragedy in which terrorists detonated a bomb at the Boston Marathon's finish line; they carried out the attack by placing two homemade pressure -cooker bombs that resulted in three fatalities and numerous injuries.
              37Breaking Bad: Season 2No2022-11-23990000002595.9Short - Biography - DramaprisonIm Hwa Ryeong - a prickly - sensitive and hot -tempered queen - tries to turn her trouble making princes into proper crown princes.
              38Lockwood & Co.: Season 1Yes2022-12-2197800000267.1Comedy - Talk -Showparty -teenager -sex comedyIt's 1940's Australia and siblings Maggie and Charles must endure taunts of newly enlisted teenagers - grapple with the fact that neither of them can fight in the war and resort to chess in order to pass the time.
              39You: Season 3Yes2022-05-209760000078.7Animation - Comedy -  SciFifemale full frontal nudity -female nudity -female frontal nudity -sex scene -country in titleElliott - a young fisherman with an extraordinary voice - gets the chance of a lifetime when high -profile music manager Suzanne discovers him at a party.
              40Breaking Bad: Season 5No2023-01-19951000008407.5Dramafrench -vacation -europe -chest hair -male nudityElliott - a young fisherman with an extraordinary voice - gets the chance of a lifetime when high -profile music manager Suzanne discovers him at a party.
              41Welcome to Eden: Season 2 // Bienvenidos a Edén: Temporada 2Yes2022-01-28946000002379.3Documentary - Shortbikini -women -young -f rated -best friendThe relationship of a well -known journalist and a down -to -earth teacher goes through hard times when she takes a new job.
              42CoComelon: Season 2No2023-03-2492900000437824.9Action - Adventure - Dramalawyer -spin off -psychosomatic illness -criminal lawyer -drug tradeIn spite of their many differences - Cassie - a struggling singer -songwriter - and Luke - a troubled Marine - agree to marry solely for military benefits - but when tragedy strikes - the line between real and pretend begins to blur.
              43The Blacklist: Season 1No2020-12-10922000001484057.9Biography - Crime - Dramamale nudity -quirky comedy -love -island -escapeTwo rival newsreel photographers join forces to find an aviatrix's missing brother - who has disappeared in the Amazon rainforest.
              44Shadow and Bone: Season 1Yes2021-05-3191400000161096.6Drama - History - Waranglo saxon -kingdom -exploration -warrior -epicA woman's life is turned upside -down when a dangerous man gets hold of her lost cell phone and uses it to track her every move.
              45The Unbroken Voice: Season 1 // Canto para no llorar - Arelys Henao: Temporada 1NoNULL91200000559797Animation - Adventure - ComedybusinessmanA woman's life is turned upside -down when a dangerous man gets hold of her lost cell phone and uses it to track her every move.
              46Demon Slayer: Kimetsu no Yaiba: Tanjiro Kamado - Unwavering Resolve Arc // 鬼滅の刃: 竈門炭治郎 立志編NoNULL87200000496.8Comedyboston marathon -boston marathon bombing -bomb -year 2013 -manhuntTen gorgeous singles meet in a tropical paradise. Little do they know that to win the EUR200 -000 prize - they'll have to completely give up sex.
              47That 90s Show: Part 1YesNULL86100000566.3Short - Horrorcharacter name as title -22nd century -future -robot -futuristicThis docuseries examining the chilling true stories of four Korean leaders claiming to be prophets exposes the dark side of unquestioning belief.
              48You: Season 2Yes2017-08-3186100000118698.4Shortschool -hero -academy -master -witchThe trials and tribulations of criminal lawyer Jimmy McGill in the years leading up to his fateful run -in with Walter White and Jesse Pinkman.
              49All of Us Are Dead: Season 1 // 지금 우리 학교는: 시즌 1Yes2022-11-15854000001936.6Documentarydonghua -chinese animation -chinese anime -team sports -basketballThis shocking documentary chronicles a happy -go -lucky nomad's ascent to viral stardom and the steep downward spiral that resulted in his imprisonment.
              50Black Knight: Season 1 // 택배기사: 시즌 1Yes2023-04-1384600000496.8Comedyperformer -fisherman -song -life -managerA quirky - dysfunctional family's road trip is upended when they find themselves in the middle of the robot apocalypse and suddenly become humanity's unlikeliest last hope.
              51Breaking Bad: Season 4No2017-07-2384400000118698.4Shortperformer -fisherman -song -life -managerDeep in the Dovre mountain - something gigantic wakes up after a thousand years in captivity. The creature destroys everything in its path and quickly approaches Oslo.
              52Obsession: Limited SeriesYes2023-01-208360000089536.8Adventure - Biography - Dramaeducational film -world war two -enemy -japanese soldier -training filmComedian Chris Rock performs a live stand -up special in Baltimore - Maryland.
              53Who Were We Running From?: Limited Series // Biz Kimden Kaçıyorduk Anne?: Mini DiziYes2023-04-1483200000111884.8Drama - Thrillerheist -robbery -spain -mint -professorAfter finding out their babies were switched at birth - two women develop a plan to adjust to their new lives creating a single and very peculiar family.
              54Hunger // คนหิว เกมกระหายYes2021-10-14825000002379.3Documentary - Shortjournalist -teacherWhat if everything we know about prehistory is wrong? Journalist Graham Hancock visits archaeological sites around the world investigating if a civilization far more advanced than we ever believed possible existed thousands of yea...
              55Alice in Borderland: Season 1 // 今際の国のアリス: シーズン1Yes2022-12-1582100000118698.4Shortanglo saxon -kingdom -exploration -warrior -epicFramed for a corporate crime - an adult Ted Templeton turns back into the Boss Baby to live undercover with his brother - Tim - posing as one of his kids.
              56CoComelon: Season 3No2021-08-218170000010927.8Dramasequel -second part -wattpad -love -windowSpinoff of Bling Empire (2021) series. Follows a group of humorous - sophisticated and rich Asian -Americans from New York City.
              57Firefly Lane: Season 1Yes2022-12-2581000000875.7Short - Comedy - Musicallove -singer -heart -two word title -color in titleA travelling monk and his followers find themselves trapped in a land inhabited by only women.
              58S.W.A.T. (2017): Season 1No2022-12-3078200000331796.9Action - Drama - Historyplot twist -criminal -smartphone -worker -cell phoneFood competition that follows the country's best backyard smokers and competitive barbecuers as they compete for the title of American Barbecue Champion.
              59Murder MysteryYes2023-01-2678200000368.5Animation - Action - Adventureplot twist -criminal -smartphone -worker -cell phoneRaquel's longtime crush on her next -door neighbor turns into something more when he starts developing feelings for her - despite his family's objections.
              60True Beauty // 여신강림No2023-04-07778000003265.7Comedy - Dramaactress -love -reference to pamela anderson -personal -careerWhen a psychiatrist shelters a mysterious cult escapee - her world is turned upside down as the girl's arrival threatens to tear her own family apart.
              61Squid Game: Season 1 // 오징어 게임: 시즌 1Yes2016-07-1577800000167064.7Action - Comedy - Dramaairplane -heist -diamond -accident -planeThis Sportscope short features the sport of kayaking. Participants ride river rapids and show their skill as they maneuver through special 'water slalom' courses.
              62Little Angel: Volume 2Yes2022-11-0976300000167084.7Action - Comedy - Dramaanthology -midnight -horrific -horrifying -sinisterHospital Playlist tells the story of five doctors who have been friends since they entered medical school in 1999.
              63Manifest: Season 2No2023-03-03757000006201439Crime - Dramalawyer -spin off -psychosomatic illness -criminal lawyer -drug tradeWhen a stay -at -home dad who dedicates all his time to his children is persuaded to take time off for himself - he gets mixed up in the wild shenanigans of his childhood friend who's celebrating his 44th birthday.
              64ExtractionYes2020-08-2175200000118698.4Shortanglo saxon -kingdom -exploration -warrior -epicThe Seven Deadly Sins travel to the Sky Temple in search of an elusive ingredient.
              65Lucifer: Season 1No2021-01-05716000003656.3Animation - Short - Horrordonghua -chinese animation -chinese anime -team sports -basketballMatchmaker Sima Taparia guides clients in the U.S. and India in the arranged marriage process - offering an inside look at the custom in a modern era.
              66The Last Kingdom: Seven Kings Must DieYes2023-03-046950000054005.8Thrilleryacht -the future -ensemble cast -italy -florence italyAfter the death of their father - two half -brothers find themselves on opposite sides of an escalating conflict with tragic consequences.
              67CoComelon: Season 4No2021-08-28690000002505327.3Crime - Drama - Mysterysnake -crocodile -spider -koala -animalAfter accidentally crash -landing in 2022 - time -traveling fighter pilot Adam Reed teams up with his 12 -year -old self for a mission to save the future.
              68Sam & Cat: Season 1No2023-03-316850000091097Adventure - Comedy - Familyrobot -road trip -dog -furby -family road tripA policeman and his doctor wife have some marriage problems and the son blames the mother. For his job - the policeman investigates a case of a missing boy. The possible kidnapping looks like some cases from a few years ago.
              69Gilmore Girls: Season 1Yes2021-11-126810000052866.5Animation - Adventure - Comedyolder woman younger man sex -deep cleavage -large breasts -female topless nudity -cuckolded husbandA live -action adaptation of Nickelodeon's Winx Club (2004). It follows Bloom as she adjusts to life in the Otherworld - where she must learn to control her dangerous magical powers.
              70Sonic Prime: Season 1Yes2021-11-176780000062827.5Documentary - Crime - Historyfather daughter relationship -mountain -oslo norway -folklore -mythological creatureAn astronaut's return after a 30 -year disappearance rekindles a lost love and sparks interest from a corporation determined to learn why he hasn't aged.
              71Manifest: Season 3No2017-09-2867200000102065.5Action - Adventure - Dramamotherhood -switched at birth -female female kiss -female nudity -female friendsWhen an army of powerful alien beings is unleashed on Earth threatening life as we know it - a brand -new team of Power Rangers - fueled by the prehistoric power of the dinosaurs - are recruited to deal with the threat.
              72Roald Dahls Matilda The MusicalYesNULL67000000343275.9Action - Comedy - Dramacardboard cutout -watching tv -watching oneself on tv -boxer -boxingThe world's deadliest assassin and New York's biggest screw -up are mistaken for each other at an Airbnb rental.
              73Sing (2016)No2022-12-136590000023968.5Comedy - Dramaworld -civilizationFrom war -torn Syria to the 2016 Rio Olympics - two young sisters embark on a harrowing journey as refugees - putting both their hearts and champion swimming skills to heroic use.
              74Hajime no Ippo: The Fighting!: Season 1 // はじめの一歩: シーズン1No2022-12-2565300000148.4Animation - Drama - Sportsequel -sequel to tv series -based on film -baby -bossFrom war -torn Syria to the 2016 Rio Olympics - two young sisters embark on a harrowing journey as refugees - putting both their hearts and champion swimming skills to heroic use.
              75Sky High: The Series: Season 1 // Hasta el cielo: La serie: Season 1Yes2022-10-136440000066766.4Drama - Music - Romancemonk -journey to the west -sun wukong the monkey king character -3d -3 dimensionalA propaganda film - made in the early months of World War II - dramatizing a new group of U.S. Army Air Force pilots receiving their wings from Lt. General H.H. Arnold: on off -screen narrator introduces four of them to us - we see th...
              76Record of Ragnarok: Season 2 // 終末のワルキューレ: シーズン2No2022-09-2163500000265.9Short - Documentaryrepeat sequel -question mark in title -returning character killed off -writer director -sequelKyra Berry - a 14 year old USA gymnast arrives in Australia to try and win a scholarship at an elite Gymnastics Academy. It's a second chance but also her last.
              77Paw Patrol: The MovieNo2022-12-08620000003516.5DramarevengeIvan Locke - a dedicated family man and successful construction manager - receives a phone call on the eve of the biggest challenge of his career that sets in motion a series of events that threaten his carefully cultivated existence.
              78Next in Fashion: Season 2Yes2021-10-0161500000118698.4Shortwattpad -love -young -teenage girl -teenage boyAfter the murder of his parents when he was a little kid - Mexican Miguel Garza is sent away to Japan. 20 years later - he has to go back to his home country as the new heir of his family's cartel.
              79Gilmore Girls: Season 2Yes2014-09-3061100000288.1Shortcult -psychiatrist -tv mini series -devil -location in titleAfter her mother disappears - Clary must venture into the dark world of demon hunting - and embrace her new role among the Shadowhunters.
              80Treason: Limited SeriesYes2023-02-1560600000484356.7Drama - Music - Romancedoctor -medical -friendship -colleagues -workAfter moving his family into his childhood home - a man's investigation into a local factory accident connected to his father unveils dark family secrets.
              81TrollsNo2023-03-2960100000331796.9Action - Drama - Historymale nudity -male star appears nude -father -life -friendAfter moving his family into his childhood home - a man's investigation into a local factory accident connected to his father unveils dark family secrets.
              82Blood Ties: Season 1 // Las Villamizar: Season 1No2015-08-285990000071467Documentary - Crimebased on manga -based on anime -holy knight -based on tv series -based on anime seriesThe Seven Deadly Sins travel to the Sky Temple in search of an elusive ingredient.
              83Money Heist: Part 1 // La casa de papel: Parte 1Yes2023-01-045960000016486.6Adventure - Comedy - Dramaboat -village -fishing -yorkshire england -lifeboatA look at the 2001 Seattle Mariners who tied Major League Baseballs modern day record for most wins in a season with 116.
              84Rough Diamonds: Season 1Yes2021-12-17593000006847.6Documentary - Shortspongebob squarepants character -sequel -king -kidnapping -friendshipThis RKO -Pathe short film promotes the need for cooperation and neighborliness in the event of a nuclear disaster and associated civil defense procedures. After preaching the power of modern (for 1956) atomic weapons - civil defens...
              85The Walking Dead: Season 10No2022-08-125830000090116.4Crime - Drama - Mysteryottoman empire -christian -constantinople turkey -medieval times -1400sAn unhappily married aristocrat begins a torrid affair with the gamekeeper on her husband's country estate.
              86The Witcher: Season 1Yes2022-07-2258300000122557.2Documentary - Biographycinepanettone -politician -ancient romeTwo inseparable friends move to Kyoto to chase their dreams of becoming maiko - but decide to pursue different passions while living under the same roof.
              87The Walking Dead: Season 3No2022-08-055670000078.7Animation - Comedy -  SciFidetective -runaway -fight -teenager -teenage girlA storm rages. A young girl is kidnapped. Her mother teams up with the mysterious woman next door to pursue the kidnapper - a journey that tests their limits and exposes shocking secrets from their pasts.
              88Gilmore Girls: Season 3Yes2022-03-31566000006201439Crime - Dramaheist -robbery -spain -mint -professorA young girl discovers a secret map to the dreamworld of Slumberland - and with the help of an eccentric outlaw - she traverses dreams and flees nightmares - with the hope that she will be able to see her late father again.
              89Red Rose: Season 1Yes2023-02-2256500000331796.9Action - Drama - Historylove -life -airport -flight -coupleGirl Luba had a dream. She - the daughter of a chess king in a fairyland - became the victim of a cunning political conspiracy of two cards  - the Peak Jack Krivello and the Cross Dame Dvuliche.
              90Gilmore Girls: Season 5Yes2023-02-14552000008107.1Documentary - Crimebased on series of novels -based on tv series -innocent cop framed -ex cop -police corruptionA live -action adaptation of Nickelodeon's Winx Club (2004). It follows Bloom as she adjusts to life in the Otherworld - where she must learn to control her dangerous magical powers.
              91Stranger Things 2Yes2023-05-2453800000646.6Short - Sportdigoxin -mercy -murder of wife -old woman -hospitalWith a little help from his brother and accomplice - Tim - Boss Baby tries to balance family life with his job at Baby Corp headquarters.
              92Red NoticeYes2022-05-0653000000357.6Short - Comedydinosaur adventure -superhero -superhero team -morphing -villainA young man is magically turned a merman - and discovers his underwater origins - after he comes in contact with the magic waters at the mysterious Mako Island guarded by a trio of mermaids.
              93Henry Danger: Season 1No2020-12-25528000002379.3Documentary - Shortmistaken identity -buddy comedy -toronto ontario canada -evil woman -final showdownA family of former child heroes - now grown apart - must reunite to continue to protect the world.
              94The Queen of Flow: Season 2 // La reina del flow: Temporada 2No2020-12-25528000008874.6Action - Comedynonlinear timeline -criminal as protagonist -killer as protagonist -gangster -truck driverSawako Kuronuma is misunderstood due to her resemblance to the ghost girl from The Ring. But one day the nicest boy in the class - Kazehaya befriends her and everything changed after that and also everyone perspective of Sawako but...
              95The Walking Dead: Season 2No2023-06-0752500000569.3Talk -Showboy -city -career -boat -olympianAfter failing to find success on Broadway - April returns to her hometown and reluctantly is recruited to train a misfit group of young dancers for a big competition.
              96Designated Survivor: Season 2Yes2021-10-11524000001037.3Short - Drama - Thrillerspaceship -robot -alien -sabotage -scientistIt follows singles in the US and Israel as they turn their dating life over to a top Jewish matchmaker.
              97Bebefinn: Season 1Yes2023-05-1052200000569.3Talk -Showpatriotism -military pilot -u.s. military -propaganda -u.s. army air corpsA team of rapid -fire renovators takes big risks and makes painstaking plans to transform families' homes from top to bottom in just 12 hours.
              98Hotel Transylvania 2No2018-10-2452000000474695.8Action - Adventure - Dramanon fictionTwo meddling grannies trick their adult grandkids into a meet -cute that reignites a childhood crush and old grudges.
              99Stranger Things 3Yes2022-11-1751800000111146.8Comedyprequel -zombie -safe -apocalypse -heistA high school student is forced to confront her secret crush at a kissing booth.
              100Outlander: Season 1No2020-06-20518000002379.3Documentary - Shortbased on film -spin off -gymnastic -athlete -eliteI AM NO ONE is a documentary film written - directed - and edited by Jason Hoover about a man named Charles Lake who moonlights as a serial killer in Chicago - IL.

              My Snippet

              -- Drop for retesting purposes
              DROP TABLE student.netflix2023
              XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX