maven - Importing a lzo file into java spark as dataset -


i have data in tsv format compressed using lzo. now, use these data in java spark program.

at moment, able decompress files , import them in java text files using 

    sparksession spark = sparksession.builder()             .master("local[2]")             .appname("myname")             .getorcreate();      dataset<row> input = spark.read()             .option("sep", "\t")             .csv(args[0]);      input.show(5);   // visually check if data imported correctly

where have passed path decompressed file in first argument. if pass lzo file argument, result of show illegible garbage.

is there way make work? use intellij ide , project set-up in maven.

i found solution. consists of 2 parts: installing hadoop-lzo package , configuring it; after doing this, code remain same in question, provided 1 ok lzo file being imported in single partition.

in following explain how maven project set in intellij.

  • installing package hadoop-lzo: need modify pom.xml file in maven project folder. should contain following excerpt:

    <repositories>     <repository>         <id>twitter-twttr</id>         <url>http://maven.twttr.com</url>     </repository> </repositories>  <properties>     <maven.compiler.source>1.8</maven.compiler.source>     <maven.compiler.target>1.8</maven.compiler.target> </properties>  <dependencies>      <dependency>         <!-- apache spark main library -->         <groupid>org.apache.spark</groupid>         <artifactid>spark-core_2.11</artifactid>         <version>2.1.0</version>     </dependency>      <dependency>         <!-- packages datasets , dataframes -->         <groupid>org.apache.spark</groupid>         <artifactid>spark-sql_2.11</artifactid>         <version>2.1.0</version>     </dependency>      <!-- https://mvnrepository.com/artifact/com.hadoop.gplcompression/hadoop-lzo -->     <dependency>         <groupid>com.hadoop.gplcompression</groupid>         <artifactid>hadoop-lzo</artifactid>         <version>0.4.20</version>     </dependency>  </dependencies>

this activate maven twitter repository contains package hadoop-lzo , make hadoop-lzo available project.

  • the second step create core-site.xml file tell hadoop have installed new codec. should placed somewhere in program folders. put under src/main/resources/core-site.xml , marked folder resource (right click on folder intellij project panel -> mark directory -> resources root). core-site.xml file should contain:

    <configuration>     <property>         <name>io.compression.codecs</name>         <value>org.apache.hadoop.io.compress.defaultcodec,             com.hadoop.compression.lzo.lzocodec,             com.hadoop.compression.lzo.lzopcodec,             org.apache.hadoop.io.compress.gzipcodec,             org.apache.hadoop.io.compress.bzip2codec</value>     </property>     <property>         <name>io.compression.codec.lzo.class</name>         <value>com.hadoop.compression.lzo.lzocodec</value>     </property> </configuration>

and that's it! run program again , should work!


Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more