sql - HIve CLI doesn't support MySql style data import to tables -

-

why can't import data hive cli following, hive_test table has user, comments columns.

insert table hive_test (user, comments)  value ("hello", "this test query");

hive throws following exception in hive cli

failed: parseexception line 1:28 cannot recognize input near '(' 'user' ',' in select clause

i don't want import data through csv file following testing perpose.

load data local inpath '/home/hduser/test_data.csv' table hive_test;

it's worth noting hive advertises "sql-like" syntax, rather actual sql syntax. there's no particular reason think pure sql queries run on hive. hiveql's dml documented here on wiki, , not support column specification syntax or values clause. however, support syntax:

insert table tablename1 select ... ...

extrapolating these test queries, might able following work:

insert table hive_test select 'hello', 'this test query' src limit 1

however, seem hive not optimized small-scale data manipulation. don't have hive instance test of on.


Comments

Post a Comment

Popular posts from this blog

Capture and play voice with Asterisk ARI -

-
there channel ari demo in wich can control channel state: ring, answer, play silence, play tone or audio-file ( https://github.com/asterisk/ari-examples/tree/master/channel-state , https://wiki.asterisk.org/wiki/display/ast/ari+and+channels%3a+manipulating+channel+state ) possible receive chunks (parts, buffers, etc.) of call voice (which created remote subscriber) or write chunks of voice, example array of bytes (not file) in audio format (alaw, ulow etc). you can use asterisk eagi interface voice data. other option use record or mixmonitor app record channel(channel have put stasis allow dialplan control ari) "write chunks of voice" can done application playback also can create own application using c/c++, compile asterisk , result want. no, can't redirect voice directly using ari.
Read more

c - Unrecognised emulation mode: elf_i386 on MinGW32 -

-
i'm trying make kernel, , cannot link c output assembly. ld . i'm getting error: unrecognized emulation mode: elf_i386 i'm using windows 10 professional mingw32 , msys. code using: link.ld /* * link.ld */ output_format(elf32-i386) entry(start) sections { . = 0x100000; .text : { *(.text) } .data : { *(.data) } .bss : { *(.bss) } } kernel.c /* * kernel.c */ void kmain(void) { const char *str = "my first kernel"; char *vidptr = (char*)0xb8000; //video mem begins here. unsigned int = 0; unsigned int j = 0; /* loops clears screen * there 25 lines each of 80 columns; each element takes 2 bytes */ while(j < 80 * 25 * 2) { /* blank character */ vidptr[j] = ' '; /* attribute-byte - light grey on black screen */ vidptr[j+1] = 0x07; j = j + 2; } j = 0; /* loop writes string video memory */ while(str[j] != '\0') { /...
Read more

css - HTML5 alternative for ::-moz-list-number -

-
this question exact duplicate of: custom numbering reversed ordered list 3 answers how define style list numbering in html5, compatible <ol reversed> ? i found ::-moz-list-number works in firefox. know better alternative same? i totally missed obvious reverse part. looks might need <li><span>item</span></li> , unstyle in <span> styled <li> . old answer (might useful some). you can style ::before , add content: counter(somecounter) . ol { list-style: none; counter-reset: item; } ol li::before { counter-increment: item; content: counter(item) ". "; color: red; font-weight: bold; } here's quick demo: https://jsfiddle.net/crswll/toggchgd/1/
Read more