Skip to content

Instantly share code, notes, and snippets.

@alexey-milovidov

alexey-milovidov/test.txt

Created April 18, 2018 21:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alexey-milovidov/306c3fa3e2f5946f06ff81fb73d6ce93 to your computer and use it in GitHub Desktop.
Save alexey-milovidov/306c3fa3e2f5946f06ff81fb73d6ce93 to your computer and use it in GitHub Desktop.
Download ZIP
Parsing array of wrong type
Raw
test.txt
$ echo '[1, -1]' | clickhouse-local -S 'x Array(UInt8)' --query="SELECT * FROM table"
Code: 130, e.displayText() = DB::Exception: Cannot read array from text: (at row 1)
Row 1:
Column 0, name: x, type: Array(UInt8), parsed text: "[1, "ERROR
, e.what() = DB::Exception (from 0.0.0.0:0) (in query: SELECT * FROM table), Stack trace:
0. clickhouse-local(StackTrace::StackTrace()+0x12) [0x53d67b2]
1. clickhouse-local(DB::DataTypeArray::deserializeText(DB::IColumn&, DB::ReadBuffer&) const+0x2a4) [0x7e69cb4]
2. clickhouse-local(DB::TabSeparatedRowInputStream::read(std::vector<COWPtr<DB::IColumn>::mutable_ptr<DB::IColumn>, std::allocator<COWPtr<DB::IColumn>::mutable_ptr<DB::IColumn> > >&)+0xf8) [0x872f3d8]
3. clickhouse-local(DB::BlockInputStreamFromRowInputStream::readImpl()+0xb6) [0x8731896]
4. clickhouse-local(DB::IProfilingBlockInputStream::read()+0xee) [0x7e4ee7e]
5. clickhouse-local(DB::StorageFileBlockInputStream::readImpl()+0x15) [0x8af0515]
6. clickhouse-local(DB::IProfilingBlockInputStream::read()+0xee) [0x7e4ee7e]
7. clickhouse-local(DB::ExpressionBlockInputStream::readImpl()+0x1a) [0x88dc2ba]
8. clickhouse-local(DB::IProfilingBlockInputStream::read()+0xee) [0x7e4ee7e]
9. clickhouse-local(DB::ExpressionBlockInputStream::readImpl()+0x1a) [0x88dc2ba]
10. clickhouse-local(DB::IProfilingBlockInputStream::read()+0xee) [0x7e4ee7e]
11. clickhouse-local(DB::copyData(DB::IBlockInputStream&, DB::IBlockOutputStream&, std::atomic<bool>*)+0x36) [0x7e62de6]
12. clickhouse-local(DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, DB::Context&, std::function<void (std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)>)+0x8d2) [0x89b2ce2]
13. clickhouse-local(DB::LocalServer::processQueries()+0x503) [0x54945b3]
14. clickhouse-local(DB::LocalServer::main(std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&)+0xb2b) [0x5492c4b]
15. clickhouse-local(Poco::Util::Application::run()+0x2d) [0x8fb45ed]
16. clickhouse-local(mainEntryClickHouseLocal(int, char**)+0x63) [0x5496233]
17. clickhouse-local(main+0x427) [0x53c4507]
18. /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0) [0x7fa890fc41c0]
19. clickhouse-local(_start+0x29) [0x53c4029]
Code: 130. DB::Exception: Cannot read array from text: (at row 1)
Row 1:
Column 0, name: x, type: Array(UInt8), parsed text: "[1, "ERROR
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment