In present days’ traditional database systems like SQL, we can access and store either raw text data or structured table data, but we cannot convert the raw data into tabular or structured data and store it. This drawback of SQL is overcome with the help of HQL [2] (Hive query language) and PIG (scripting language). After the data is converted, we can do the filtering and other updates using the scripting language and thus making the data more effective. In other words, we can say that this is to convert the semistructured or clumsy data into structured and effective data.

SQL, structured, HQL, PIG, Hive.