To be simple, what the escape character is when I run the below sql to create a
table.
Create table aa (a string, b string) stored as textfile;
Need help!!
> On 27 Oct 2018, at 9:27 PM, ZongtianHou wrote:
>
> If I set the escape char to ‘\’, then after I insert (‘\\’,’abc’) into a
> table (a st
If I set the escape char to ‘\’, then after I insert (‘\\’,’abc’) into a table
(a string, b string), on hdfs file the content is "\\",”abc"
But if I don’t set it, the content will become \abc, which will caused the \ be
looked as escape and the two columns table became one column, I wonder what
Hi, everyone,
I have installed hive3.0 and tried it. I created a table , but can’t insert a
record into it. Below is the operation and error info, any hint will be very
appreciated!
hive> create table ii(a int);
OK
Time taken: 1.337 seconds
hive> insert into ii values (2);
Query ID = kousouda_20