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 |
Is the keyword ‘DEFINE’ as a function name?
How can we see only top 15 records from the student.txt out of100 records in the HDFS directory?
What is the use of foreach operation in Pig scripts?
Can we say a COGROUP is a group of more than 1 data set?
What is illustrate used for in apache pig?
What is Grunt shell?
What are all stats classes in the java api package available?
Explain the architecture of Hadoop Pig?
Explain pigstorage function?
Explain the difference between COUNT_STAR and COUNT functions in Apache Pig?
What is the use of having Filters in Apache Pig ?
What are the debugging tools used for Apache Pig scripts?
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)