score:1
Accepted answer
i found the answer by myself actually the :
row format delimited fields terminated by ' ';
determinate the format of the rows in the "file.txt" that we are going to load in the table and hive’s default record and field delimiters list is :
\n
^a
^b
^c
press ^v^a could insert a ^a in vim.
or you can just do:
create table tablename (key int, value string) row format delimited fields terminated by ' ';
and the 'file.txt' should be like this:
value1 value2
value3 value4
in this example value1 and value3 represent the key and value4 and value5 represent the value
Source: stackoverflow.com
Related Query
- load data into table hive
- How to load data into android from the web
- Inserting data into sql table in Eclipse EE
- Eclipse inserting data into SQLite Database, no such table
- How do I load test data into my GWT Widget?
- Load Data into JSP Page from MySQL without Form
- insert data from table into another table if don't exist
- insert data from table into another table if don't exist
- putting data from editText into a table
- Eclipse load data from 2.3 to 4.4 every time you open an xml file
- How can I make Tycho load platform specific fragment into the test runtime for any OS?
- Android SQLiteException "no such table"while compiling: INSERT INTO table
- java.lang.OutOfMemoryError when trying to load a bitmap into imageView
- how to load the dependencies from the pom into classpath of eclipse project?
- Android eclipse Dump SQLite table row into text file
- Command failed with error 8000 (AtlasError) when try to insert data into collection on Atlast server
- Error on insert data into database using laravel5
- Program run from eclipse is able to insert data into Mongo DB of local machine but not into Mongo DB of remote machine
- Google Search API: Loading all datastore data into document builder for full text search on all records
- Load Image into JLabel not working
- JAVA sapjco3 Can't find data from returned table
- Store data into neo4j from eclipse
- I can't drag fields from joint datasets into a grid or table while using BIRT
- Eclipse data not inserting into SQLite Database and crashing
- How to load image from data resources in eclipse java
- Using "Simple" XML Serialization to load data from res/raw on Android
- How to save data a user inputs into an edittext to be viewed in another activity within the same app
- How to correctly load shared libraries into Eclipse
- Load data from jframe to the newly opened jframe
- Eclipse won't compile into bin , Could not find or load main class
More Query from same tag
- Logging output in Eclipse WTP server
- Is it possible to have Eclipse automatically insert imports for common classes
- svn:ignore for a file already committed in subclipse
- issues for birt plugin in eclipse if multiple user use it on linux at same time
- NullPointerException in Eclipse debug view right after connecting android device
- EJBs - problems running a simple tutorial example in Eclipse with JBOSS 7.1.1 server
- ClassNotFoundException from Class.forName("com.mysql.jdbc.Driver");
- Stop Eclipse from opening Logcat when running an Android app
- how to create a different workspace in eclipse for different users?
- Java db4o Storing and Retrieving
- Deploying a Maven web project on Jetty
- Programming Java GUI with Eclipse
- How can I make IEditorInput, that will read file from memory?
- Managing external JARs build paths in git controlled eclipse project created in Ubuntu and cloned in Windows
- auto rotate stops music when app rotates
- How to disable scroll in tab bar?
- Can someone tell me a different way of writing this line of code?
- JUnit 4.12: testing util classes
- Eclipse: Bundle org.eclipse.e4.ui.workbench cannot be resolved
- java.lang.NoClassDefFoundError: com/google/common/base/Function
- Attribute "background" already defined with incompatible format in Android Studio
- How to import .dll to Android java project (working with eclipse)
- pom.xml shows multiple annotations errors in Eclipse
- How to import to selenium webdriver project in eclipse ide a firefox profile in order to commit it to svn/git and use it from other machines?
- Eclipse:: Making an Apple App
- R.drawable.exit library missing?
- Error converting dynamic web project to Maven Project
- nodejs configuration using (*.p2f) file in eclipse
- Eclipse: Ignore "Undefined CSS class" warning
- Changing Tab Content Depending on Which Element of the Spinner is Selected