Member since
10-01-2015
3933
Posts
1150
Kudos Received
374
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2381 | 05-03-2017 05:13 PM | |
2019 | 05-02-2017 08:38 AM | |
2152 | 05-02-2017 08:13 AM | |
2182 | 04-10-2017 10:51 PM | |
897 | 03-28-2017 02:27 AM |
01-04-2018
05:18 PM
make sure that this error haven't caused by tables that Hive Create in your MySql database: check out if there is something looks like this error: Error: Index column size too large. The maximum column size is 767 bytes. (state=HY000,code=1709)
or just:
The maximum column size is 767 bytes
... View more
03-11-2017
02:57 AM
That's good to know! Many restrictions with Oozie...
... View more
03-10-2017
02:21 PM
I got rid off SPNEGO on this cluster and set oozie.authentication.type=simple
as I'm accessing from Mac, I don't need SPNEGO. I'm able to access Oozie UI now.
... View more
03-09-2017
09:51 PM
I'll post this as separate question
... View more
03-08-2017
10:39 AM
1 Kudo
You can pass an escaped by clause Enable escaping for the delimiter characters by using the 'ESCAPED BY' clause (such as ESCAPED BY '\')
Escaping is needed if you want to work with data that can contain these delimiter characters. https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL CREATE TABLE my_table(a string, b string, ...)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES (
"separatorChar" = "\t",
"quoteChar" = "'",
"escapeChar" = "\\"
)
STORED AS TEXTFILE;
Default properties for SerDe is Comma-Separated (CSV) file
DEFAULT_ESCAPE_CHARACTER \
... View more
03-08-2017
09:46 PM
You can upgrade Ambari to 2.4.2 and then follow the standard upgrade process to upgrade HDP from 2.3 to 2.5.3.
... View more
03-08-2017
07:15 AM
Thanks @Artem Ervits! Although I remember that I set all required passwords during the installation, I did set a password for Grafana. Now I can stop and start all services.
... View more
03-07-2017
10:14 PM
1 Kudo
I was able to edit my article now. Seems like there was an issue yesterday (not sure what was it though) as @Artem Ervits and @Jay SenSharma mentioned.
... View more