I wanted to convert one days avro data (~2 TB) to parquet.
I ran a hive query and data successfully got converted to parquet.
But the data size became 6 TB.
What would have happened that data became thrice the size?
Hive Tremendous data size increase from converting avro to parquet
269 views Asked by user2942227 At
1
There are 1 answers
Related Questions in HADOOP
- Can anyoone help me with this problem while trying to install hadoop on ubuntu?
- Hadoop No appenders could be found for logger (org.apache.hadoop.mapreduce.v2.app.MRAppMaster)
- Top-N using Python, MapReduce
- Spark Driver vs MapReduce Driver on YARN
- ERROR: org.apache.hadoop.fs.UnsupportedFileSystemException: No FileSystem for scheme "maprfs"
- can't write pyspark dataframe to parquet file on windows
- How to optimize writing to a large table in Hive/HDFS using Spark
- Can't replicate block xxx because the block file doesn't exist, or is not accessible
- HDFS too many bad blocks due to "Operation category WRITE is not supported in state standby" - Understanding why datanode can't find Active NameNode
- distcp throws java.io.IOException when copying files
- Hadoop MapReduce WordPairsCount produces inconsistent results
- If my data is not partitioned can that be why I’m getting maxResultSize error for my PySpark job?
- resource manager and nodemanager connectivity issues
- ERROR flume.SinkRunner: Unable to deliver event
- converting varchar(7) to decimal (7,5) in hive
Related Questions in HIVE
- Type Adapter for Offset in hive flutter
- HIVE Sql Date conversion
- How to set spark.executor.extraClassPath & spark.driver.extraClassPath in hive query without adding those in hive-site.xml
- Hive query on HUE shows different timestamp than programatically/on data
- descending order of data in hive using collect_set
- How to optimize writing to a large table in Hive/HDFS using Spark
- Spark SQL repartition before insert operation
- Alter datatype of complex type(array<struct>>) in hive
- SqlAlchemy connection to Hive using http thrift transport and basic auth
- Aggregate values into a new column while retaining the old column
- Is it possible to query MAPR hdfs/hive tables from Trino?
- Can we make a column having both partitioning and bucketing in hive?
- converting varchar(7) to decimal (7,5) in hive
- Extract all characters before numeric values in hive SQL
- Livy session to submit pyspark from HDFS
Related Questions in AVRO
- Incorrect Serialization and Deserialization of Union Types with dataclasses-avroschema
- Lambda function returning null parameters when receiving Kafka event
- Azure Data Factory: How to import a complex json object from Avro file
- Neo4j Source Connectors Failing to build the Schema where the source query returns null for some of the fields
- Kafka message not deserializable. How to debug
- Avro4k - Exception: Not a named type: "int"
- How to convert an avro schema into an asyncapi programatically?
- How I deserialize Avro from Kafka with spring boot 2.7.18
- What format does apache pinot use for storing segments in deep storage?
- Avro after upgrading to JDK 17
- Is there a console code formatter for Avro IDL?
- ReflectDatumWriter failing with error "Array data must be a Collection or Array"
- How to create an avro schema containing list of records for apache nifi?
- avro-tools-1.11.1.jar causes NoClassDefFoundError in my existing program
- How to figure out why Glue Schema Registry Avro Schema Evolution failed
Related Questions in PARQUET
- Polars with Rust: Out of Memory Error when Processing Large Dataset in Docker Using Streaming
- I am facing issue with ParquetFileWriting n hdfs in flink where parquet file size is around 382 KB . I want the parquet file in MB
- Packages for reading parquets in NodeJS (2024)
- ADF Copy Activity from Source Azure Synapse Analytics Target ADLSGen2 Storage account
- Worth it to access data by blocks on modern OS/hardware?
- Does having large number of parquet files causes memory overhead while reading using Spark?
- Hive query on HUE shows different timestamp than programatically/on data
- Reading partitioned parquet files with Apache Beam and Python SDK
- Read the latest S3 parquet files partitioned by date key using Polars
- redshift spectrum type conversion from String to Varchar
- Azure error writing parquet to ADLS Gen 2
- Is there any way to stream to a parquet file in Ruby?
- AWS S3 Parquet data lake: How to best deploy aggregation Python script
- TensorFlowIO: Corrupted reads of pyspark compressed spark Parquet files
- parquet Incremental updates cause disordered reading in python
Related Questions in DATA-FORMATS
- What's the difference between these two different formats of binary data?
- fast downsampling of huge matrix using python (numpy memmap, pytables or other?)
- Converting int to currency format
- EXCEL TABLE forces a field to be a date, when I supply a non-date string in SQL INSERT INTO
- Using a SAS format catalogue
- Difference between GGA and RMC sentences in NMEA
- Keras correct input shape for multilayer perceptron
- Is it possible to read and write Parquet using Java without a dependency on Hadoop and HDFS?
- socket.io with strange timestamp format (?)
- Hive Tremendous data size increase from converting avro to parquet
- Importing multiple categories on single products
- In which format to record/store numerical data for further JavaScript processing?
- Updating an excel sheet with info from another workbook
- What is the benefit to server-side JSON communication and serialization?
- What kind of data format is this (colon and semicolon separated entries)?
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Typically, Parquet can be more efficient than Avro, as it's a columnar format columns of the same type are adjacent on the disk. This allows compression algorithms to be more effective in some cases. Typically we use Snappy which is sufficient, easy on CPU and has several properties that make it suitable for Hadoop relative to other compression methods like zip or gzip. Mainly snappy is splittable; each block retains information necessary to determine schema. MParquet is a great format and we have been very happy with query performance after moving from Avro (and we also can use Impapla which is super-fast).