{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "%load_ext sparksql_magic" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "22/03/17 19:45:50 WARN ObjectStore: Version information not found in metastore. hive.metastore.schema.verification is not enabled so recording the schema version 1.2.0\n", "22/03/17 19:45:50 WARN ObjectStore: Failed to get database default, returning NoSuchObjectException\n" ] }, { "data": { "text/html": [ "
databaseName |
default |
offset |
1 |
3 |
5 |
4 |
2 |
offset |
1 |
3 |
5 |
4 |
2 |
id | credit_card | date_rent | time_rent | movie | movie_genres | offset |
date_rent | time_rent | movie | movie_genres | id | credit_card | offset |
2020-04-12 | 19:24:10 | Blinkity Blank | Animation | abae1023971539d380f71298401acd4d48791a92b19e67d00fd452b686401e54 | 18e61c9b4b33d0e198bb5d91b2c451ed341d4d3a214f1f51c2cc7f98ee6547d8 | 1 |
2020-04-12 | 3:54:29 | What Have I Done to Deserve This? (¿Qué he hecho yo para merecer esto!!) | Comedy|Drama | b3fd63acc23e666fc95b24b102ab1d7ae39ec26c4c45205b2d4c027c9c9cb966 | e2bea2000bbbe37c77e1773573b13d36a9057a19586a4902fe635719bea21ab2 | 1 |
2020-04-12 | 1:33:37 | Second in Command | Action|Thriller | c6546b74e8d033688b8800d673090d264e54b3bd921ef463c063807335b4b4f2 | 75f77c2b11155463513424b0d56f6209923711d6388f70c65308fc24090890b6 | 1 |
2020-04-12 | 4:32:28 | Buddha Collapsed Out of Shame | Drama|War | 0747df874d1cad8841a36e09fd6933f617d11179638517e3de858e534e14d554 | 61c425599469eac91e185721412aacd3c33d6de97824bb6086ef5dc89b712713 | 1 |
2020-04-12 | 16:06:10 | Mechanic, The | Action|Drama|Thriller | 6d0347ffb6b203d0bdcd592c40090c1afcaa34e2c470fb81d391435101952ee4 | 09aa5109a2327f531c860dca9fb7355b6546536c134093e9d7d7318719e13958 | 1 |
2020-04-12 | 2:03:09 | Prince & Me II: The Royal Wedding, The | Comedy|Romance | f44e68de464337affafae6e374941bfb93f31b497dc80cadfdb3fe049d372072 | 1fcbcd98bdb399d2bbb4e54dd5c569975dda151e313e4d250978564f778e0333 | 1 |
2020-04-12 | 7:23:01 | Neverland | Adventure|Fantasy | 7dd3f1ce8e9902f2e25ab006a6b043b1fe6a21a8ed23fb68f51164f98cd29d70 | ed986ee20009536b41ec2b9d5c1b4a67355c0435f8f162b87c592d74dc90eb23 | 1 |
2020-04-12 | 6:39:22 | Nine Dead | Crime|Mystery|Thriller | c6d180917fb29aa932990e4f91b7ba500022290113fc32fdeb7890518a0c2179 | 7907e94aaee1e669d0691fb249ec3a9aa593f2a0eb144bdc8427f3604d6d25cb | 1 |
2020-04-12 | 19:40:11 | One Magic Christmas | Drama|Fantasy | fc00e9897992742c919a403f3584958655310c45e11e8e76b30e44588be696a1 | 2b0c7156801270b5c5a4b21dedaa11ac8a6b320e2bf00ed0e60d7c68da570c65 | 1 |
2020-04-12 | 19:26:41 | Sachs' Disease (La maladie de Sachs) | Drama | 4d1931a512802ccd241903e6143578ed79eca7e071092abd7f097ec32a514ec0 | dddd2b1dc80a9ac760e762cae6a7522b53061fdb3df7413862745e8a6eaa1c57 | 1 |
2020-04-12 | 20:41:33 | They Shoot Horses, Don't They? | Drama | a7f4ab82a2cb8f4525744290953e5d94848c5d65eddf2d87d89cf25bce2d7b6a | 42de9da3c52fef2ef0a9f4154db6b60af601ec9d4b88dfcb8f83ea5240606d65 | 1 |
2020-04-12 | 12:58:30 | Ghost in the Shell 2: Innocence (a.k.a. Innocence) (Inosensu) | Action|Animation|Drama|Sci-Fi|Thriller | 1de000473a2c2b24c015267a782671d96b03ee80ebc097d4458fa44e3df71976 | 8b397c6893d8a187ff0c87e60afa47bd349ba1b38da43fb7ed34eb5936562873 | 1 |
2020-04-12 | 22:08:18 | Non-Stop | Action|Comedy|Crime | 976c48b49f3ac5876c1324890637240cd690d26810aa075e4e532d4dfc3f7e51 | 652bc8dc0330e6e9ea3301e446eb0be45994c2d7b927f9e301d31c004ef72645 | 1 |
2020-04-12 | 6:40:17 | One Body Too Many | Comedy|Horror|Mystery | 44ed348fcdfa8dc1c989a3472fb09ec9ee80caca16a58f0c57f5eac69746e6fa | b574f4e7faf1573ad6dc1f3a337432e14a774ce726b420dc94886340cddb32cb | 1 |
2020-04-12 | 4:44:23 | Passed Away | Comedy | d49af67241e07bcd226e947eb174d90863765639e8f6a19cdb95d0e58fd5748a | 20673f87a6755a1e2d77eac8eab9ffaac617b749e8c53511a8ab3ad6ad0f8b26 | 1 |
2020-04-12 | 16:43:55 | Pursuit of Happiness | Comedy|Romance | 58de4007dce28d93f72a40c9c14f8939823e1247a1f02e9419d33357af5e4d8b | 861441ca5191a2a2088145669ea531a90be9d50f00b75402d1829f4a0f803c45 | 1 |
2020-04-12 | 11:43:12 | North Star (a.k.a. Tashunga) | Action|Adventure|Crime|Drama|Western | b5885124f7f8f227b40f9d56960685ece9f3e341a8f9e5fd20c7c30c45b33ba8 | 1ee1de023446e2fd47ecdc4695895271a97c10c715df0e8de2ad21a87f4e2866 | 1 |
2020-04-12 | 16:29:11 | Casual Sex? | Comedy | c782d5c8ff7f1f91c0166689c5d104c39461ea850fd1a3de16d61b71ba5eb4ef | fd858d4abd3206ec89acb4ade3922c491eb429efbca47795454f9f29c3caa116 | 1 |
2020-04-12 | 1:27:27 | Crush, The | Thriller | 3a1670bb3d0aee9d93115126512c79611291451e714b9bf03fc11054a78f84bb | 6375f466b8e88eb53a47b4340af43dfa0e7f68dacd61a55d0baba5d3d4ed158e | 1 |
2020-04-12 | 22:54:40 | Horns | Horror|Mystery | 3c94fec6ab03a123da5292db9e40104c4f03b08fddf7ec2efcfe45a91a20a550 | 5e00419da3f9fdb642319d6cc07fa3395563f97c87c67d237d3374876b73e27d | 1 |
id | credit_card | date_rent | time_rent | movie | movie_genres | offset |
1 | 4903136325452740870 | 2020-04-12 | 10:52:53 | Dry Cleaning (Nettoyage à sec) | Drama | 1 |
2 | 3577491551960733 | 2020-04-12 | 4:42:13 | Alone (Issiz adam) | Drama|Romance | 1 |
3 | 3536874685193000 | 2020-04-12 | 16:53:05 | Family Stone, The | Comedy|Drama|Romance | 1 |
4 | 344681715118362 | 2020-04-12 | 22:55:42 | Man Who Captured Eichmann, The | Drama|War | 1 |
5 | 5048375443966618 | 2020-04-12 | 5:27:32 | Desperately Seeking Susan | Comedy|Drama|Romance | 1 |
6 | 201621133610618 | 2020-04-12 | 15:12:07 | Caine (Shark!) | Action|Adventure|Thriller | 1 |
7 | 4017952805033425 | 2020-04-12 | 1:45:48 | The Scapegoat | Drama | 1 |
8 | 4017957934466107 | 2020-04-12 | 12:35:09 | Injury to One, An | Documentary | 1 |
9 | 337941060394011 | 2020-04-12 | 5:19:47 | Skeleton Crew | Horror | 1 |
10 | 6399834887430831 | 2020-04-12 | 1:01:10 | Age of Ice | Adventure|Sci-Fi | 1 |
11 | 4917378918567862 | 2020-04-12 | 20:15:35 | Godzilla's Revenge (Gojira-Minira-Gabara: Oru Kaijû Daishingeki) (All Monsters Attack) | Children | 1 |
12 | 5561535137109182 | 2020-04-12 | 19:01:21 | Mrs. Pollifax-Spy | null | 1 |
13 | 3561177898358529 | 2020-04-12 | 23:18:28 | Muppets From Space | Children|Comedy | 1 |
14 | 5100149952659509 | 2020-04-12 | 18:48:35 | God Said 'Ha!' | Comedy | 1 |
15 | 3552265907987601 | 2020-04-12 | 17:35:02 | 3000 Miles to Graceland | Action|Thriller | 1 |
16 | 30388059445901 | 2020-04-12 | 22:40:37 | Transmorphers | Action|Adventure|Sci-Fi | 1 |
17 | 3557314418688574 | 2020-04-12 | 17:49:14 | Suspect | Crime|Drama|Thriller | 1 |
18 | 3560389149794441 | 2020-04-12 | 4:56:02 | Timecrimes (Cronocrímenes, Los) | Sci-Fi|Thriller | 1 |
19 | 3529468841475960 | 2020-04-12 | 10:33:51 | Horseman, The | Crime|Thriller | 1 |
20 | 6763943473044817241 | 2020-04-12 | 22:09:07 | Raging Bull | Drama | 1 |
date_rent | time_rent | movie | movie_genres | id | credit_card | offset |
2020-04-12 | 21:48:57 | Himizu | Children|Crime|Drama | 5a3d36f3c5fd7c57f33c564590ff5132a999c9c52934f7d2d76773231a14ee1a | 24ce6a634ce326653cc3369ffaba5077dde7029f4d5dfd3b5500b757909801fd | 1 |
2020-04-12 | 7:23:01 | Neverland | Adventure|Fantasy | 7dd3f1ce8e9902f2e25ab006a6b043b1fe6a21a8ed23fb68f51164f98cd29d70 | ed986ee20009536b41ec2b9d5c1b4a67355c0435f8f162b87c592d74dc90eb23 | 1 |
2020-04-12 | 4:26:29 | 99 francs | Comedy | e75d986b87db8a9f803ecf8388e8d2f60817c5cf14dd32d566f01a161a08ea3f | 186c0ba3bc0e0d47892882b5fa298a24b6be89ed0c0541d3d485bb9f6b7cdf97 | 1 |
2020-04-12 | 19:26:41 | Sachs' Disease (La maladie de Sachs) | Drama | 4d1931a512802ccd241903e6143578ed79eca7e071092abd7f097ec32a514ec0 | dddd2b1dc80a9ac760e762cae6a7522b53061fdb3df7413862745e8a6eaa1c57 | 1 |
2020-04-12 | 13:13:24 | Cabin Boy | Comedy | 99fc323d8ed63269908df021afd3f5e71a945fdf5ae76e081d7d6eebb56cb8a2 | e9d0136c647b810cfd4837add2fb31a5072ab1074da305eaffa1f742001bd13a | 1 |
2020-04-12 | 1:20:44 | Laila | Drama|Romance | a992199c0b5a96c67ef35d54367bb373d86d025607948d07f87fefe3ed896fd0 | 5152d7d99e156aafb8f527cbe0f5a8ecb2f888c68dfedeca5f5ac20b22e2779a | 1 |
2020-04-12 | 14:45:48 | Magnificent Seven, The | Adventure|Western | cc836f5987b01318435a75ff6d0e6598b8902f2cc9e14e9d6d787edba366deb9 | a0081d6c93bf48fb9577513d326be5f226e0bd20e3853045cfaf3ea9dd3fbb35 | 1 |
2020-04-12 | 6:24:04 | Beautiful | Drama|Thriller | 666a5391d3a9e296dae35207d4fba459c33bb64dcc3e56019699b3b51f1d289f | ca6aebaef15fd1e193767adfff913b072c17787d6a91a835f5e1cc625f843a92 | 1 |
2020-04-12 | 13:53:53 | U Turn | Crime|Drama|Mystery | abeab0626396b2a733f517eae43287e38ced15ce7006296a385e2f9a56ea4517 | d107052dc40b767b532d327020e03b3d664db3ecdf0bbc6bac3908316fc06e75 | 1 |
2020-04-12 | 1:17:46 | Kill the Irishman | Action|Crime | 29c6ebf11da7419171f8f780dfffa6f92aed43a81c553c6cebd3e2f9aa3e91ec | 0415c7791fcea322c8ab2cc8663364e24723151bcb749159430cc763970d628d | 1 |
2020-04-12 | 6:32:16 | Nazis: A Warning from History, The | Documentary|War | 72f02662a32787464b4d4de34f045624e7c1f52247eb4f320f71290e0fa18b82 | 99f7505cd0cf8175875823476f32a2a7dc46a43e56ad801c79cab447e0b9a3eb | 1 |
2020-04-12 | 2:22:36 | Not My Type | Comedy|Romance | 9cf959a5170d8139a42e925277f1a81cc7b8d87755bf2e250fabf1ae7021030f | cc46c3752e143b7af0aaa4b19a94764d19a17a39308dd04797ceba4f86065b97 | 1 |
2020-04-12 | 23:39:21 | Partners: The Movie II (Aibô: Gekijô-ban II) | Drama | ccce3a074af34d3021814f212aa066e8dcc89dc0e88e4f8f1c112b6a788ff6ab | 4ac0245808f665c6b1ba18e2923314e87b017e46f5d998483801ea337672ab5b | 1 |
2020-04-12 | 15:20:53 | Lost in the Desert | null | 1ec60d1a29e3852cc7c41e2396ecb9b94eb3aa4547cfe638734921581bc59f95 | 0321c89ea8f3cdddd2b4cadf5e1cd369822b4b9a47cea5356fc4c19bd87c5287 | 1 |
2020-04-12 | 12:47:58 | 3 Ninjas: High Noon On Mega Mountain | Action|Children|Comedy | f7ad3d340a57d32472e9cc52e6083c4829f657ccce89cd269a5e6e0a332ec00b | dc398f1dd4b9461e2e79834e51ee776c4d10d8c9b43132db1abcd650846f63ee | 1 |
2020-04-12 | 4:38:44 | Forty Shades of Blue | Drama | 017baa8bcd349fe30bf83f7de5bf008fdd0d703a01ff644a94d0cfc14369f5c2 | c8247c128245059c8f1b5453ac5475618ad9f6fd5927c926502151f86d989613 | 1 |
2020-04-12 | 20:22:42 | Funny People | Comedy|Drama | 58de4007dce28d93f72a40c9c14f8939823e1247a1f02e9419d33357af5e4d8b | 38ed94f3068651e045327e0d02683419500dd66b6adf7759e827c714b8667460 | 1 |
2020-04-12 | 17:20:55 | Wedding Gift, The | Drama|Romance | 543cf4238c6291216c7cd2eb7442e0811b38e1389d27734a64e913b4084c23e6 | 5a8106f74d232adbb320556341465f02fe1f4fd0950f015f962aa34534592bfd | 1 |
2020-04-12 | 20:01:01 | Delirious | Comedy|Drama | c3c66b769c6b2aec4436b958a8e668b29aad8606f5148fd7889ef5442af2ae15 | bc2d673ba5763613aa7fee155dde6d67311fa05f1b62788eec8d3ae2d1f3b887 | 1 |
2020-04-12 | 6:42:28 | Boys Life 4: Four Play | Comedy|Drama | 9b9e2ce075d949d957b2d7f5a8b3203627987ddd85d9493085aa894c81332742 | e6b85d5006cdc836aadd20d8e7c2ed8dee8ed8fea8031d32a47467e61fa7d879 | 1 |