Thursday, October 29, 2020

Cara Menghapus 'Recently Watched Shows' di Netflix (PC/Mac)

untuk menghapus daftar recently watched shows di netflix yang terpasang di PC/Mac, silakan lakukan langkah berikut:

  1. Login ke akun masing-masing. Dan klik pada menu Your Account

  2. Klik tanda ikon panah ke bawah

  3. lalu klik pada menu View Activity

  4. Pilih menu Hide All di bawah

How to Create a Table in Apache Hive

Apache Hive is a data warehousing tool used to perform queries and analyze structured data in Apache Hadoop. Hive gives an SQL-like interface to query data stored in various databases and file systems that integrate with Hadoop. Traditional SQL queries must be implemented in the MapReduce Java API to execute SQL applications and queries over distributed data. Hive provides the necessary SQL abstraction to integrate SQL-like queries (HiveQL) into the underlying Java without the need to implement queries in the low-level Java API.

In this article, learn how to create a table in Hive and load data. We will also show you crucial HiveQL commands to display data.

A table in Hive is a set of data that uses a schema to sort the data by given identifiers. The general syntax for creating a table in Hive is:

[sourcecode lang="sql"]CREATE [EXTERNAL] TABLE [IF NOT EXISTS] [db_name.]table_name
(col_name data_type [COMMENT 'col_comment'],, ...)
[COMMENT 'table_comment']
[ROW FORMAT row_format]
[STORED AS file_format];

  1. Create database in Apache Hive,

create database example;

  1. Verify your database, is it already created?

show example;

  1. Open your database

use example;

  1. Create the 'products' table:

create table products (id int, name string, sku string, price string, quantity int)

How to Delete Remote Git Branch

Git is a project-tracking application that creates a main project thread that can be branched. Git branches are used to develop changes and updates without affecting the core project. Files in a branch may need to be deleted if they become corrupted or obsolete after merging branches.

Your remote branch is located on a different system; usually, a server like Github, Gitlab, Bitbucket or your personal Git Repository. When you delete a remote branch,it will removed from all users also.

Delete a remote Git branch by entering the following command:

git push remote_project --delete branch_name

There is one alternative, use the following command to delete a remote branch:

git push remote_project :branch_name

In some cases, this may generate an error that indicates that the branch has already been deleted.

Tuesday, October 20, 2020

Cara Copy File ke USB Flashdisk di Chromebook

Untuk melakukan copy file dan paste file dari dan ke USB flashdisk, sebenarnya mirip-mirip di hampir semua operating system. Bagi yang menggunakan Chromebook, silakan ikuti tutorial berikut:

  1. masukkan USB flashdisk ke port USB Chromebook. pastikan flashdisk tersebut terdeteksi dengan keluar notifikasi ada "Removable device".

2. kemudian buka aplikasi Files

  1. Copy file dan paste ke USB Flashdisk.