what is difference between pig and sql?
Answer / Sumant Kumar
Pig Latin and SQL are both high-level data query languages, but they have some differences: 1) Pig Latin is designed specifically for working with large datasets stored in Hadoop Distributed File System (HDFS), while SQL can be used with various databases. 2) Pig Latin provides a higher level of abstraction, allowing users to work with data using procedural and functional operations, whereas SQL follows a more traditional declarative approach. 3) Pig Latin supports UDFs (User Defined Functions), which can help extend the functionality of the platform, while SQL has limited support for custom functions.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between Apache Pig and Hive?
Explain about the execution plans of a pig script?<Br> or<br> differentiate between the logical and physical plan of an apache pig script?
How to write 'foreach' statement for map datatype in pig scripts?
What are the different pig data types?
Mention the common features in Pig and Hive?
Explain count_star?
What co-group does in Pig?
You have a file employee.txt in the hdfs directory with 100 records. You want to see only the first 10 records from the employee.txt file. How will you do this?
Why Do We Need Apache Pig?
what is pig?
Can you join multiple fields in apache pig scripts?
What are the different Eval functions available in Pig?
Apache Hadoop (394)
MapReduce (354)
Apache Hive (345)
Apache Pig (225)
Apache Spark (991)
Apache HBase (164)
Apache Flume (95)
Apache Impala (72)
Apache Cassandra (392)
Apache Mahout (35)
Apache Sqoop (82)
Apache ZooKeeper (65)
Apache Ambari (93)
Apache HCatalog (34)
Apache HDFS Hadoop Distributed File System (214)
Apache Kafka (189)
Apache Avro (26)
Apache Presto (15)
Apache Tajo (26)
Hadoop General (407)